Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Default list of stored procs and functions(udfs) in oracle?

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 26 Jan 2006 12:28:53 -0800
Message-ID: <1138307330.375622@jetspin.drizzle.com>


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)
Received on Thu Jan 26 2006 - 14:28:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US