Query dba_objects for owner name and object type : dba_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial
- Oracle PL/SQL Tutorial
- System Tables Data Dictionary
- dba_objects
SQL>
SQL> SELECT object_name
2 from dba_objects
3 WHERE owner = 'SYS'
4 AND object_type = 'PACKAGE'
5 ORDER BY object_name;
OBJECT_NAME
--------------------------------------------------------------------------------
DBMSHSXP
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMSOBJG_DP
DBMSZEXP_SYSPKGGRNT
DBMS_ADVANCED_REWRITE
DBMS_ADVISOR
DBMS_ALERT
DBMS_APPCTX
DBMS_APPLICATION_INFO
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_APPLY_ADM
DBMS_APPLY_ADM_INTERNAL
DBMS_APPLY_ERROR
DBMS_APPLY_PROCESS
DBMS_APPLY_USER_AGENT
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_SYS
DBMS_AQADM_SYSCALLS
DBMS_AQELM
DBMS_AQIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AQJMS
DBMS_AQJMS_INTERNAL
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_INV
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_SYS_IMP_INTERNAL
DBMS_ASH_INTERNAL
DBMS_ASSERT
DBMS_ASYNCRPC_PUSH
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AW
DBMS_AW_EXP
DBMS_BACKUP_RESTORE
DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_PROCESS
DBMS_CHANGE_NOTIFICATION
DBMS_CLR
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_TOOLKIT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_CRYPTO_TOOLKIT_TYPES
DBMS_DATAPUMP
DBMS_DATAPUMP_UTL
DBMS_DBLINK
DBMS_DBVERIFY
DBMS_DB_VERSION
DBMS_DDL
DBMS_DDL_INTERNAL
DBMS_DEBUG
DBMS_DEBUG_JDWP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DEBUG_JDWP_CUSTOM
DBMS_DEFER
DBMS_DEFERGEN
DBMS_DEFERGEN_AUDIT
DBMS_DEFERGEN_INTERNAL
DBMS_DEFERGEN_LOB
DBMS_DEFERGEN_PRIORITY
DBMS_DEFERGEN_RESOLUTION
DBMS_DEFERGEN_UTIL
DBMS_DEFERGEN_WRAP
DBMS_DEFER_ENQ_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DEFER_IMPORT_INTERNAL
DBMS_DEFER_INTERNAL_QUERY
DBMS_DEFER_INTERNAL_SYS
DBMS_DEFER_QUERY
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_REPCAT
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_DESCRIBE
DBMS_DIMENSION
DBMS_DISTRIBUTED_TRUST_ADMIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DRS
DBMS_EPG
DBMS_ERRLOG
DBMS_EXPORT_EXTENSION
DBMS_EXTENDED_TTS_CHECKS
DBMS_FBT
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT
DBMS_FGA
DBMS_FILE_GROUP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_FILE_GROUP_DECL
DBMS_FILE_GROUP_EXP
DBMS_FILE_GROUP_EXP_INTERNAL
DBMS_FILE_GROUP_IMP
DBMS_FILE_GROUP_IMP_INTERNAL
DBMS_FILE_GROUP_INTERNAL_INVOK
DBMS_FILE_GROUP_UTL
DBMS_FILE_GROUP_UTL_INVOK
DBMS_FILE_TRANSFER
DBMS_FLASHBACK
DBMS_FREQUENT_ITEMSET
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_HA_ALERTS
DBMS_HA_ALERTS_PRVT
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_UTL
DBMS_IAS_CONFIGURE
DBMS_IAS_INST
DBMS_IAS_INST_UTL
DBMS_IAS_INST_UTL_EXP
DBMS_IAS_MT_INST
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_IAS_MT_INST_INTERNAL
DBMS_IAS_QUERY
DBMS_IAS_SESSION
DBMS_IAS_TEMPLATE
DBMS_IAS_TEMPLATE_INTERNAL
DBMS_IAS_TEMPLATE_UTL
DBMS_IJOB
DBMS_INDEX_UTL
DBMS_INTERNAL_LOGSTDBY
DBMS_INTERNAL_REPCAT
DBMS_INTERNAL_SAFE_SCN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_INTERNAL_TRIGGER
DBMS_IREFRESH
DBMS_ISCHED
DBMS_ISCHED_CHAIN_CONDITION
DBMS_ISNAPSHOT
DBMS_ITRIGGER_UTL
DBMS_I_INDEX_UTL
DBMS_JAVA_DUMP
DBMS_JAVA_TEST
DBMS_JOB
DBMS_LCR
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_LDAP
DBMS_LDAP_API_FFI
DBMS_LDAP_UTL
DBMS_LOB
DBMS_LOCK
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_INTERNAL
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_SESSION
DBMS_LOGREP_DEF_PROC_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
DBMS_LOGSTDBY
DBMS_MAINT_GEN
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DPBUILD
DBMS_METADATA_INT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_METADATA_UTIL
DBMS_MONITOR
DBMS_OBFUSCATION_TOOLKIT
DBMS_OBFUSCATION_TOOLKIT_FFI
DBMS_ODCI
DBMS_OFFLINE_INTERNAL
DBMS_OFFLINE_OG
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
DBMS_OFFLINE_UTL
DBMS_OUTPUT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_PCLXUTIL
DBMS_PICKLER
DBMS_PIPE
DBMS_PITR
DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_PREPROCESSOR
DBMS_PROFILER
DBMS_PROPAGATION_ADM
DBMS_PROPAGATION_INTERNAL
DBMS_PRVTAQIM
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_PRVTAQIP
DBMS_PRVTAQIS
DBMS_PRVTRMIE
DBMS_PRVT_TRACE
DBMS_PSP
DBMS_PSWMG_IMPORT
DBMS_RANDOM
DBMS_RCVMAN
DBMS_RECOVERABLE_SCRIPT
DBMS_RECO_SCRIPT_INT
DBMS_RECO_SCRIPT_INVOK
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RECTIFIER_DIFF
DBMS_RECTIFIER_FRIENDS
DBMS_REDEFINITION
DBMS_REFRESH
DBMS_REFRESH_EXP_LWM
DBMS_REFRESH_EXP_SITES
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
DBMS_REGISTRY_SYS
DBMS_REGXDB
DBMS_REPAIR
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT
DBMS_REPCAT_ADD_MASTER
DBMS_REPCAT_ADMIN
DBMS_REPCAT_AUTH
DBMS_REPCAT_CACHE
DBMS_REPCAT_COMMON_UTL
DBMS_REPCAT_CONF
DBMS_REPCAT_DECL
DBMS_REPCAT_EXP
DBMS_REPCAT_FLA
DBMS_REPCAT_FLA_MAS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_FLA_UTL
DBMS_REPCAT_INSTANTIATE
DBMS_REPCAT_INTERNAL
DBMS_REPCAT_INTERNAL_PACKAGE
DBMS_REPCAT_MAS
DBMS_REPCAT_MIG
DBMS_REPCAT_MIGRATION
DBMS_REPCAT_MIG_INTERNAL
DBMS_REPCAT_OBJ_UTL
DBMS_REPCAT_OUTPUT
DBMS_REPCAT_RGT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_RGT_ALT
DBMS_REPCAT_RGT_CHK
DBMS_REPCAT_RGT_CUST
DBMS_REPCAT_RGT_CUST2
DBMS_REPCAT_RGT_EXP
DBMS_REPCAT_RGT_UTL
DBMS_REPCAT_RPC
DBMS_REPCAT_RPC_UTL
DBMS_REPCAT_RQ
DBMS_REPCAT_SNA
DBMS_REPCAT_SNA_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_SQL_UTL
DBMS_REPCAT_UNTRUSTED
DBMS_REPCAT_UTL
DBMS_REPCAT_UTL2
DBMS_REPCAT_UTL3
DBMS_REPCAT_UTL4
DBMS_REPCAT_VALIDATE
DBMS_REPUTIL
DBMS_REPUTIL2
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RESUMABLE
DBMS_RLS
DBMS_RMGR_GROUP_EXPORT
DBMS_RMGR_PACT_EXPORT
DBMS_RMGR_PLAN_EXPORT
DBMS_RMIN
DBMS_ROWID
DBMS_RULE
DBMS_RULEADM_INTERNAL
DBMS_RULE_ADM
DBMS_RULE_COMPATIBLE_90
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RULE_EXIMP
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RL_INTERNAL
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULES
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTL
DBMS_RULE_EXP_UTLI
DBMS_RULE_IMP_OBJ
DBMS_SCHEDULER
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SCHED_CHAIN_EXPORT
DBMS_SCHED_CLASS_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS
DBMS_SCHED_JOB_EXPORT
DBMS_SCHED_MAIN_EXPORT
DBMS_SCHED_PROGRAM_EXPORT
DBMS_SCHED_SCHEDULE_EXPORT
DBMS_SCHED_WINDOW_EXPORT
DBMS_SCHED_WINGRP_EXPORT
DBMS_SCHEMA_COPY
DBMS_SERVER_ALERT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SERVER_ALERT_EXPORT
DBMS_SERVER_ALERT_PRVT
DBMS_SERVER_TRACE
DBMS_SERVICE
DBMS_SESSION
DBMS_SNAPSHOT
DBMS_SNAPSHOT_UTL
DBMS_SNAP_INTERNAL
DBMS_SNAP_REPAPI
DBMS_SPACE
DBMS_SPACE_ADMIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SQL
DBMS_SQLHASH
DBMS_SQLPLUS_SCRIPT
DBMS_SQLTUNE
DBMS_SQLTUNE_INTERNAL
DBMS_STANDARD
DBMS_STATS
DBMS_STATS_INTERNAL
DBMS_STAT_FUNCS
DBMS_STAT_FUNCS_AUX
DBMS_STORAGE_MAP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_DATAPUMP
DBMS_STREAMS_DATAPUMP_UTIL
DBMS_STREAMS_DECL
DBMS_STREAMS_LCR_INT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_MT
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
DBMS_STREAMS_TBS_INT
DBMS_STREAMS_TBS_INT_INVOK
DBMS_SUMADV
DBMS_SUMADVISOR
DBMS_SUMMARY
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SUMREF_UTIL
DBMS_SUMVDM
DBMS_SUM_RWEQ_EXPORT
DBMS_SUM_RWEQ_EXPORT_INTERNAL
DBMS_SWRF_INTERNAL
DBMS_SWRF_REPORT_INTERNAL
DBMS_SYSTEM
DBMS_SYS_ERROR
DBMS_SYS_SQL
DBMS_TDB
DBMS_TDE_TOOLKIT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_TDE_TOOLKIT_FFI
DBMS_TRACE
DBMS_TRANSACTION
DBMS_TRANSACTION_INTERNAL_SYS
DBMS_TRANSFORM
DBMS_TRANSFORM_EXIMP
DBMS_TRANSFORM_EXIMP_INTERNAL
DBMS_TRANSFORM_INTERNAL
DBMS_TSM
DBMS_TSM_PRVT
DBMS_TTS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_TYPES
DBMS_TYPE_UTILITY
DBMS_UNDO_ADV
DBMS_UPGRADE_INTERNAL
DBMS_UTILITY
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_WORKLOAD_REPOSITORY
DBMS_XMLGEN
DBMS_XMLSTORE
DBMS_XPLAN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XRWMV
DBMS_ZHELP
DBMS_ZHELP_IR
DIANA
DIUTIL
HTF
HTMLDB_SYSTEM
HTP
KUPC$QUEUE
KUPC$QUEUE_INT
KUPC$QUE_INT
OBJECT_NAME
--------------------------------------------------------------------------------
KUPCC
KUPD$DATA
KUPD$DATA_INT
KUPF$FILE
KUPF$FILE_INT
KUPM$MCP
KUPP$PROC
KUPV$FT
KUPV$FT_INT
KUPW$WORKER
LCR$_XML_SCHEMA
OBJECT_NAME
--------------------------------------------------------------------------------
LOGMNR_DICT_CACHE
ODCICONST
OUTLN_EDIT_PKG
OUTLN_PKG
OWA
OWA_CACHE
OWA_COOKIE
OWA_CUSTOM
OWA_CX
OWA_IMAGE
OWA_MATCH
OBJECT_NAME
--------------------------------------------------------------------------------
OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
PBREAK
PBRPH
PBSDE
PBUTL
PIDL
PLITBLM
OBJECT_NAME
--------------------------------------------------------------------------------
PRVT_ACCESS_ADVISOR
PRVT_ADVISOR
PRVT_DIMENSION_SYS_UTIL
PRVT_HDM
PRVT_SYS_TUNE_MVIEW
PRVT_TUNE_MVIEW
PRVT_UADV
PRVT_WORKLOAD
PRVT_WORKLOAD_NOPRIV
STANDARD
SYS_STUB_FOR_PURITY_ANALYSIS
OBJECT_NAME
--------------------------------------------------------------------------------
URIFACTORY
UTL_COLL
UTL_COMPRESS
UTL_ENCODE
UTL_FILE
UTL_GDK
UTL_HTTP
UTL_I18N
UTL_INADDR
UTL_LMS
UTL_MATCH
OBJECT_NAME
--------------------------------------------------------------------------------
UTL_RAW
UTL_RECOMP
UTL_REF
UTL_SMTP
UTL_SYS_COMPRESS
UTL_TCP
UTL_URL
UTL_XML
WPG_DOCLOAD
WPIUTL
WWV_FLOW_VAL
OBJECT_NAME
--------------------------------------------------------------------------------
XML_SCHEMA_NAME_PRESENT
441 rows selected.
SQL>
SQL>