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






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>








30.37.dba_objects
30.37.1.Query dba_objects for owner name and object type
30.37.2.Get the creation time and updated time for dba objects
30.37.3.Query dba_objects by owner
30.37.4.Get all system packages
30.37.5.List all sys owned package name