3.17 ALL_PROCEDURES
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 theOWNER
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 |
|
|
|
Indicates whether the function is result–cached ( |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
The type of polymorphic table function:
|
Note:
SQL macros for table expressions are supported starting with Oracle Database release 19c, version 19.7. In future releases, the ALL_
, DBA_
, and USER_PROCEDURES
data dictionary views contain a column called SQL_MACRO
, which enables you to identify the SQL macros in your database. However, this column is not available in Oracle Database 19c. Instead, refer to My Oracle Support note 2678637.1 "How To Identify the SQL Macros in Oracle Data Dictionary 19.7 Onwards" at the following URL to learn how to identify SQL macros in Oracle Database 19c:
See Also:
-
"ALL_ARGUMENTS" for information about the arguments of the functions and procedures that are accessible to the current user