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

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

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>