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	Description
  OWNER	VARCHAR2(30)	Owner of the procedure
  OBJECT_NAME	VARCHAR2(30)	Name of the object: top-level function, procedure, or package name
  PROCEDURE_NAME	VARCHAR2(30)	Name of the procedure
  AGGREGATE	VARCHAR2(3)	(YES/NO) Identifies whether or not the procedure is an aggregate function
  PIPELINED	VARCHAR2(3)	(YES/NO) Indicates whether or not the procedure is a pipelined table function
  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)	(YES/NO) Indicates whether or not the procedure or function is parallel-enabled