Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_PROCEDURES

ALL_PROCEDURES lists all functions and procedures, along with associated properties. For example, ALL_PROCEDURES indicates whether or not a function is pipelined, parallel enabled or an aggregate function. If a function is pipelined or an aggregate function, the associated implementation type (if any) is also identified.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the procedure
OBJECT_NAME VARCHAR2(30) NOT NULL Name of the object: top-level function, procedure, or package name
PROCEDURE_NAME VARCHAR2(30)   Name of the procedure
OBJECT_ID NUMBER   Object number of the object
SUBPROGRAM_ID NUMBER   Unique subprogram identifier
OVERLOAD VARCHAR2(40)   Overload unique identifier
OBJECT_TYPE VARCHAR2(19)   The typename of the object
AGGREGATE VARCHAR2(3)   Indicates whether the procedure is an aggregate function (YES) or not (NO)
PIPELINED VARCHAR2(3)   Indicates whether the procedure is a pipelined table function (YES) or not (NO)
IMPLTYPEOWNER VARCHAR2(30)   Owner of the implementation type, if any
IMPLTYPENAME VARCHAR2(30)   Name of the implementation type, if any
PARALLEL VARCHAR2(3)   Indicates whether the procedure or function is parallel-enabled (YES) or not (NO)
INTERFACE VARCHAR2(3)   YES, if the procedure/function is a table function implemented using the ODCI interface; otherwise NO
DETERMINISTIC VARCHAR2(3)   YES, if the procedure/function is declared to be deterministic; otherwise NO
AUTHID VARCHAR2(12)   Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker)