Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get the creation time and updated time for dba objects

SQL> SQL> COLUMN     object_name FORMAT a25 SQL> COLUMN     created FORMAT a20 SQL> COLUMN     updated FORMAT a20 SQL> SELECT     object_name, object_type,   2             TO_CHAR(created, 'MM/DD/YY HH24:MI:SS') created,   3             TO_CHAR(last_ddl_time, 'MM/DD/YY HH24:MI:SS') updated   4  FROM       dba_objects   5  WHERE      object_type IN ('PACKAGE','PACKAGE BODY', 'PROCEDURE',   6                             'FUNCTION', 'TRIGGER')   7  AND        OWNER        = 'PLSQL_USER'   8  and        rownum < 50   9  ORDER BY   object_name; no rows selected SQL>