Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Views
adamr1000_at_hotmail.com (Adam Rothberg) wrote in message news:<68326679.0211041547.70bd9118_at_posting.google.com>...
> Does anyone know a query I can run against the DBA_xxx views to obtain
> all packages' names within a schema and the names of the functions and
> procedures defined within each package? Similar to the way you can
> join DBA_TABLES and DBA_TAB_COLUMNS to get a list of all tables and
> the columns in those tables
SELECT name ,text
FROM all_source
WHERE type='PACKAGE'
AND owner='owner_name'
ORDER BY line;
doing so you receive the specification
of all packages owned by <owner_name>.
If you want the specifications of the
package of the current user simply use
the USER_SOURCE view.
From Oracle documentation
ALL_SOURCE describes the text source of all stored objects accessible to the user
DBA_SOURCE describes the text source of all stored objects in the database. Its columns are the same as those in "ALL_SOURCE"
USER_SOURCE contains text source of all
stored objects belonging to the user.
Its columns are the same as those in "ALL_SOURCE"
Before posting such a question please visit:
For information about DBA_*, ALL_* and USER_* views please consult:
http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96536/toc.htm
(you need a free subscription).
Mario from Rome Received on Tue Nov 05 2002 - 07:53:15 CST