Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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.