List all sys owned package name : dba_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

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.

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