Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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.