Get the creation time and updated time for dba objects : dba_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_objects

SQL>
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>