Information on Functions and Procedures in a Package

The user_procedures view has information on your functions and procedures in a package. Some of the columns in user_procedures:

Column	Type	Description
OBJECT_NAME	VARCHAR2(30)	The object name, which may be a procedure, function, or package name
PROCEDURE_NAME	VARCHAR2(30)	The procedure name
AGGREGATE	VARCHAR2(3)	Whether the procedure is an aggregate function(YES or NO)
IMPLTYPEOWNER	VARCHAR2(30)	owner
IMPLTYPENAME	VARCHAR2(30)	name
PARALLEL	VARCHAR2(3)	Whether the procedure is enabled for parallel queries (YES or NO)


SQL> SELECT object_name, procedure_name
  2  FROM user_procedures
  3  WHERE object_name = 'EMP_PACKAGE';

OBJECT_NAME                    PROCEDURE_NAME
------------------------------ ------------------------------
EMP_PACKAGE                    GET_EMP_REF_CURSOR
EMP_PACKAGE                    UPDATE_SALARY

SQL>

Home »
Oracle »
PL/SQL »

Packages: