ALL_PROCEDURES
lists all functions and procedures that are accessible to the current user, 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 available in the database, along with associated properties.
USER_PROCEDURES
lists all functions and procedures owned by the current user, along with associated properties. It does not contain the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the procedure |
|
|
|
Name of the object: top-level function, procedure, or package name |
|
|
|
Name of the procedure |
|
|
|
Object number of the object |
|
|
|
Unique subprogram identifier |
|
|
|
Overload unique identifier |
|
|
|
The typename of the object |
|
|
|
Indicates whether the procedure is an aggregate function ( |
|
|
|
Indicates whether the procedure is a pipelined table function ( |
|
|
|
Owner of the implementation type, if any |
|
|
|
Name of the implementation type, if any |
|
|
|
Indicates whether the procedure or function is parallel-enabled ( |
|
|
|
|
|
|
|
|
|
|
|
Indicates whether the procedure/function is declared to execute as |
|
|
|
The ID of the container where the data originates. Possible values include:
|
See Also:
"ALL_ARGUMENTS" for information about the arguments of the functions and procedures that are accessible to the current user