Re: Oracle in-built packages.

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 22 Jun 2009 12:25:16 -0700
Message-ID: <bf46380906221225w6ee3bba7ud87066f711490a79_at_mail.gmail.com>

>
> On Fri, Jun 19, 2009 at 11:29 AM, Paresh Patel <
> paresh.patel_at_mantis-tgi.com> wrote:
>
> Listers,
>
>
>
> 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.
>

* *
**Documentation:
I would provide a link, but the Oracle Doc site is currently down. Go to otn.oracle.com later and click on documentation.

The manual you need is "PL/SQL Packages and Types Reference"

This as of 10g. It had a funky "Supplied Packages" name in earlier versions.

Also:

select name, type, line, text
from dba_source
where owner = 'SYS'
order by 1,2,3;

Much of it will be unreadable.

You can also browse the OH/*/admin directories.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Mon Jun 22 2009 - 14:25:16 CDT