| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
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
DBA_PROCEDURES lists all functions and procedures, along with associated properties.
USER_PROCEDURES lists all functions and procedures, along with associated properties. It does not contain the OWNER column.
| 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 | |
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) |
Name of the 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) |
