Oracle PL/SQL Tutorial/System Tables Data Dictionary/all procedures

Get information on all the procedures you have access to using all_procedures.

   <source lang="sql">

SQL> SQL> desc all_procedures;

Name                  Null?    Type
----------------------
OWNER                 NOT NULL VARCHAR2(30)
OBJECT_NAME           NOT NULL VARCHAR2(30)
PROCEDURE_NAME                 VARCHAR2(30)
AGGREGATE                      VARCHAR2(3)
PIPELINED                      VARCHAR2(3)
IMPLTYPEOWNER                  VARCHAR2(30)
IMPLTYPENAME                   VARCHAR2(30)
PARALLEL                       VARCHAR2(3)
INTERFACE                      VARCHAR2(3)
DETERMINISTIC                  VARCHAR2(3)
AUTHID                         VARCHAR2(12)

SQL> SQL> --select * from all_procedures; SQL> SQL> SQL></source>