Combine dba_tables and dba_tab_columns, dba_objects : dba_tab_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_tab_columns

SQL>
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