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.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the procedure
OBJECT_NAME VARCHAR2(128)   Name of the object: top-level function, procedure, or package name
PROCEDURE_NAME VARCHAR2(128)   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(13)   Object type
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(128)   Owner of the implementation type, if any
IMPLTYPENAME VARCHAR2(128)   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)
RESULT_CACHE VARCHAR2(3)   Indicates whether the function is result-cached (YES) or not (NO)
ORIGIN_CON_ID VARCHAR2(256)  

The ID of the container where the data originates. Possible values include:

  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)

POLYMORPHIC VARCHAR2(5)  

The type of polymorphic table function:

  • ROW

  • TABLE

  • LEAF

  • NULL
SQL_MACRO VARCHAR2(6)  

Indicates whether the procedure is a SQL macro. Possible values:

  • SCALAR: The procedure is a SQL macro for a scalar expression
  • TABLE: The procedure is a SQL macro for a table expression
  • NULL: The procedure is not a SQL macro
BLOCKCHAIN VARCHAR2(3)   For internal use only
BLOCKCHAIN_MANDATORY_VOTES VARCHAR2(4000)   For internal use only
DYNAMIC_SAMPLING_ONFoot 1 VARCHAR2(3)   YES, if the dynamic statistics function preference is set to ON for this function; otherwise NO
DYNAMIC_SAMPLING_OFFFoot 1 VARCHAR2(3)   YES, if the dynamic statistics function preference is set to OFF for this function; otherwise NO
DYNAMIC_SAMPLING_CHOOSEFoot 1 VARCHAR2(3)   YES, if the dynamic statistics function preference is set to CHOOSE for this function; otherwise NO
IS_FUNCTIONFoot 1 VARCHAR2(3)   Indicates whether this is a function (YES) or not (NO)
IS_PROCEDUREFoot 1 VARCHAR2(3)   Indicates whether this is a procedure (YES) or not (NO)

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.8.

See Also: