Hi , With 9i and 10g, where can I find documentation or a list of
stored procs/functions (udfs) in oracle, that can be invoked for admin
or other issues by end users.

Thanks
Aakash

On 24 Jan 2006 15:03:28 -0800, "Aakash" <bordia (AT) gmail (DOT) com> wrote:

Oracle supplied packages manual at http://tahiti.oracle.com

--
Sybrand Bakker, Senior Oracle DBA

Aakash wrote:
As Sybrand says: tahiti.oracle.com.

For demos of many of them go to Morgan's Library at www.psoug.org.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

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

Aakash wrote:
SELECT object_name
FROM all_arguments
WHERE package_name = '<your_package_name_here>';
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)