Get all system packages : dba_objects « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_objects

Get all system packages

    
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.

   
    
    
    
  

Related examples in the same category