List all sys owned package name : dba_objects « System Tables Views « Oracle PL / SQL






List all sys owned package name

   

SQL> select object_name
  2   from dba_objects
  3   where owner = 'SYS'
  4   and object_type = 'PACKAGE';
Enter...

STANDARD
DBMS_STANDARD
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
XML_SCHEMA_NAME_PRESENT
UTL_RAW
DBMS_ADVISOR
PLITBLM
SYS_STUB_FOR_PURITY_ANALYSIS
PIDL
DIANA
DIUTIL
DBMS_PICKLER
DBMS_JAVA_TEST
UTL_FILE
UTL_TCP
UTL_INADDR
UTL_SMTP
UTL_HTTP
UTL_URL
UTL_ENCODE
Enter...

UTL_GDK
DBMS_LOB
UTL_SYS_COMPRESS
UTL_COMPRESS
UTL_I18N
UTL_LMS
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_SPACE_ADMIN
DBMS_TYPES
DBMS_TRANSACTION
DBMS_SESSION
DBMS_UTILITY
DBMS_ROWID
DBMS_PCLXUTIL
DBMS_ERRLOG
DBMS_ASSERT
DBMS_SPACE
DBMS_TRANSACTION_INTERNAL_SYS
DBMS_APPLICATION_INFO
DBMS_LOCK


442 rows selected.

   
    
    
  








Related examples in the same category

1.Query dba_objects table group by object_type
2.Query object name by object id against dba_objects
3.list table, table partition, index, index partition and lob from dba_objects
4.List all not valid database objects
5.Get all system packages