Oracle 约会吗？

SQL> select owner, table_name, column_name
  2  from   dba_tab_columns
  3  where  data_type = 'DATE'
  4  or data_type like 'TIMESTAMP%';

OWNER                          TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------ -------------------
SYS                            TS$                            SPARE4
SYS                            ICOL$                          SPARE6
SYS                            USER$                          CTIME
SYS                            USER$                          PTIME
...
...
复制