view Oracle dbms packages

[fatchoy]

Hi

How can I view all the built in package of oracle database.
(by SQLPlus command or any oracle tool)

Pls advise

 

[AOLEURO]

Hi

just use desc PackageName;

ex. desc dbms_output; gives you:

PROCEDURE DISABLE
PROCEDURE ENABLE
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
BUFFER_SIZE NUMBER(38) IN DEFAULT
PROCEDURE GET_LINE
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
LINE VARCHAR2 OUT
STATUS NUMBER(38) OUT
PROCEDURE GET_LINES
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
LINES TABLE OF VARCHAR2(255) OUT
NUMLINES NUMBER(38) IN/OUT
PROCEDURE NEW_LINE
PROCEDURE PUT
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
A VARCHAR2 IN
PROCEDURE PUT
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
A NUMBER IN
PROCEDURE PUT_LINE
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
A VARCHAR2 IN
PROCEDURE PUT_LINE
Argumentnavn Type Ind/Ud Standard?
------------------------------ ----------------------- ------ --------
A NUMBER IN
Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[GrSw]

select  object_name from all_objects
where object_type = 'PACKAGE' and
      object_name like 'DBMS%'

or

select  object_name from all_objects
where object_type = 'PACKAGE' and
      owner = 'SYS'

or use the tool, like TOAD.

Hope this helps
Grzegorz

 

[Georgdba]

hi -
try this sql - command :
select distinct object_type,status from all_objects where upper(OBJECT_TYPE) like 'PACKAG%' ;

greetings
george