Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query a table in user_table by table_name

SQL> SQL> create table t(   2    a int   3  ); Table created. SQL> SQL> SQL> select table_name, tablespace_name   2    from user_tables   3   where table_name = 'T'; TABLE_NAME                     TABLESPACE_NAME ------------------------------ ------------------------------ T                              SYSTEM SQL> SQL> drop table t; Table dropped. SQL>