Thursday, July 24, 2014

Find when the table is created

Find when the TABLE is created

SELECT created  FROM dba_objects WHERE object_name='ASP_USER' AND owner='PORTAL' AND object_type = 'TABLE';
select table_name, to_char(create_date, 'yyyy-mm-dd') from all_tables where table_name='table_name' group by table_name;




No comments:

Post a Comment