ALL_PROCEDURES

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)