Wednesday, June 4, 2014

Find when the table was 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='ASP_USER' group by table_name;



 

No comments:

Post a Comment