Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Combine dba_tables and dba_tab_columns, dba_objects

SQL> SQL> SELECT a.table_name,b.column_name, c.created   2  FROM dba_tables a, dba_tab_columns b, dba_objects c   3  WHERE a.table_name = b.table_name   4      AND a.table_name = c.object_name   5      AND a.tablespace_name = 'GRAPHICS_DATA'   6      AND object_type = 'TABLE'; no rows selected