Information on Functions

The user_procedures view has information on your functions. 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)	The owner
IMPLTYPENAME	VARCHAR2(30)	The name
PARALLEL	VARCHAR2(3)	Whether the procedure is enabled for parallel queries (YES or NO)


SQL>
SQL> SELECT object_name, aggregate, parallel
  2  FROM user_procedures
  3  WHERE object_name IN ('CIRCLE_AREA', 'AVERAGE_SALARY');

OBJECT_NAME                    AGG PAR
------------------------------ --- ---
AVERAGE_SALARY                 NO  NO
CIRCLE_AREA                    NO  NO

SQL>

Home »
Oracle »
PL/SQL »

Functions:

Create a function
Call a function with named and mixed notation
Return the average salary
Information on Functions
Dropping a Function