CREATE FUNCTION

Create a stand-alone function or a call spec.

Syntax:

   CREATE [OR REPLACE] FUNCTION [schema.]function [arguments_clause]
      RETURN datatype [invoke_clause]
         AS plsql_function_body

   CREATE [OR REPLACE] FUNCTION [schema.]function [arguments_clause]
      RETURN datatype [invoke_clause]
         AS LANGUAGE JAVA NAME 'string'

   CREATE [OR REPLACE] FUNCTION [schema.]function [arguments_clause]
      RETURN datatype [invoke_clause]
         AS LANGUAGE C [NAME name] LIBRARY lib_name [WITH CONTEXT][PARAMETERS params]

arguments_clause:
   (argument [IN|OUT|IN OUT] [NOCOPY datatype])

invoke_clause: 
any combination of...
   AUTHID CURRENT_USER
   AUTHID DEFINER
   DETERMINISTIC
   PARALLEL_ENABLE

Related Commands:

FUNCTION - ALTER FUNCTION
FUNCTION - DROP FUNCTION
PACKAGE - CREATE PACKAGE
LIBRARY - CREATE LIBRARY

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE 




Back to the Top

Simon Sheppard
SS64.com