Re: Default list of stored procs and functions(udfs) in oracle?

Aakash wrote:
> Hi Guys, thanks for the links and reference to Oracle9i Supplied PL/SQL
> Packages. I was looking up the catalog tables sys.all_objects and it
> seems only the package names for the packages like DBMS_STATS are
> stored in there.Where could I find catalog entries to the subprograms
> like DBMS_STATS.GET_TABLE_STATS? That is somehow not mentioned in the
> reference,or atleast I could not find it.
> Another thing is I was able to execute these on sqlplus, so that means
> they are installed atleast.
>
> Thanks
> Aakash

SELECT object_name
FROM all_arguments
WHERE package_name = '<your_package_name_here>';

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)