Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>