SQL-查看某天新建的表的名称和建表时间

SQL-查看某天新建的表的名称和建表时间

select object_name ,to_char(created,'yyyy-mm-dd hh24:mm:ss') from user_objects 
where object_type='TABLE' and to_char(created,'yyyy-mm-dd')='2016-08-02';