Get all system packages : 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> select object_name
  2  from dba_objects
  3  where owner = 'SYS'
  4  and object_type = 'PACKAGE';

OBJECT_NAM
----------
STANDARD
DBMS_STAND
ARD

DBMS_REGIS
TRY

442 rows selected.








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