Re: Oracle in-built packages

> Does any data dictionary view contain information about all Oracle in-built
> packages? I can see DBA_LIBRARIES shows some of in-built packages but not
> all.

Libraries or packages? They're two different types of objects.

The most reliable way to list all built-in packages (not libraries!) is 
probably find or create a vanilla database and check dba_objects where 
object_type='PACKAGE' and owner='SYS'. To find more information about them, 
read "PL/SQL Packages and Types Reference" in documentation (titled differently 
in 9i), and supplement with header text in dba_source especially for those 
undocumented. Note that not all built-in packages are named like DBMS% or UTL%. 
Sometimes information at
http://www.psoug.org/library.html
also helps.

Yong Huang


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: