Oracle PL-SQL Interview Question:

Give the structure of the function?

Submitted by: Administrator

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;
Submitted by: Administrator

CREATE OR REPLACE FUNCTION FUNCTION_NAME(PARAMETERS)
RETURN RETURN_TYPE;
IS
DECLARATION_SECTION
BEGIN
EXECUTION_SECTION
RETURN RETURN_VARIABLE;
EXCEPTION
EXECUTION_SECTION
RETURN RETURN_VARIABLE;
END;
Submitted by: Suraj