OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » dbms packages

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms packages [message #63117]

Fri, 10 September 2004 22:53

mb
Messages: 51
Registered: March 2001

Member

hi,

how can I see the list of procedures and functions and source of dbms packages

for example dbms_stats package

Report message to a moderator

Re: dbms packages [message #63120 is a reply to message #63117]

Sun, 12 September 2004 22:25

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Do a describe in SQL*Plus:

SQL> desc dbms_stats
PROCEDURE CONVERT_RAW_VALUE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 RAWVAL                         RAW                     IN
 RESVAL                         VARCHAR2                OUT
PROCEDURE CONVERT_RAW_VALUE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
...
...
...

Or, you could look at the Supplied PL/SQL Packages and Types Reference. This can be found among your Oracle documentation. The link directs you to the 9.2 version. At http://tahiti.oracle.com you can choose the version of the documentation you need. It requires a free subscription.

MHE

Report message to a moderator

Re: dbms packages [message #64002 is a reply to message #63117]

Sat, 04 December 2004 02:36

SABARISH
Messages: 1
Registered: December 2004

Junior Member

hi,
how can i know the cost,vendor name, versions,special features of different types of database packages

Report message to a moderator

Previous Topic:	Pl Help : Shared Server configuration Prob:
Next Topic:	error-ORA-01426 WHILE TAKING EXPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:04:52 CST 2025