The ALL_PROCEDURES view provides information about all PL/SQL functions and procedures, along with associated properties, that are accessible to the current user.
| Column name | Data type | Description |
|---|---|---|
OWNER |
VARCHAR2(30) |
The owner of the procedure or function. Always INLINE. |
OBJECT_NAME |
VARCHAR2(30) |
The name of the object, which may be a top-level function, procedure, or package. Always INLINE. |
PROCEDURE_NAME |
VARCHAR2(30) |
The name of the procedure or function. Always INLINE. |
OBJECT_ID |
TT_BIGINT |
The number of the object. Always NOT NULL. |
SUBPROGRAM_ID |
NUMBER |
A unique subprogram identifier. Always NOT NULL. |
OVERLOAD |
VARCHAR2(12) |
An overload unique identifier. Always INLINE. |
OBJECT_TYPE |
VARCHAR2(17) |
The type of the object. Always INLINE. |
AGGREGATE |
VARCHAR2(3) |
Specifies whether the object is an aggregate function (YES) or not (NO). Always INLINE, NOT NULL. |
PIPELINED |
VARCHAR2(3) |
Specifies whether the object is a pipelined table (YES) or not (NO). Always INLINE, NOT NULL. |
IMPLTYPEOWNER |
VARCHAR2(30) |
The owner of the implementation type. Always INLINE. |
IMPLTYPENAME |
VARCHAR2(30) |
The name of the implementation type. Always INLINE. |
PARALLEL |
VARCHAR2(3) |
Specifies whether the procedure or function is parallel-enabled (YES) or not (NO). Always NOT NULL, INLINE. |
INTERFACE |
VARCHAR2(3) |
Specifies whether the procedure or function is a table function implemented using the Oracle Data Cartridge Interface (ODCI) (YES) or not (NOT). Always NOT NULL, INLINE. |
DETERMINISTIC |
VARCHAR2(3) |
Specifies whether the procedure or function is declared to be deterministic (YES) or not (NO).Always NOT NULL, INLINE. |
AUTHID |
VARCHAR2(12) |
Specifies whether the procedure or function is declared to execute with the privileges of its definer (DEFINER) or the invoking user (CURRENT_USER). Always INLINE, NOT NULL. |