Which Of The Following Is The Correct Syntax For Creating A #553
Which of the following is the correct syntax for creating a function in PL/SQL?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 PL/SQL Procedures, Functions and Cursors - PL/SQL Function - Quiz No.1.
Which of the following is the correct syntax for creating a function in PL/SQL?
CREATE [OR REPLACE] FUNCTION function_name [(parameter_name [IN | OUT | IN OUT] type [, ...])] RETURN return_value {IS | AS} BEGIN <function_body> END [function_name];CREATE [OR REPLACE] FUNCTION function_name [(parameter_name [IN | OUT | IN OUT] type [, ...]) {IS | AS} BEGIN <function_body> END [function_name];CREATE [OR REPLACE] FUNCTION [(parameter_name [IN | OUT | IN OUT] type [, ...])] RETURN return_value BEGIN <function_body> END [function_name];REPLACE FUNCTION function_name [(parameter_name [IN | OUT | IN OUT] type [, ...])] RETURN return_value {IS | AS} BEGIN <function_body> END [function_name];
