Which two statements are correct about the usage of parameters in functions? (Choose two.)
A.
Functions can have only in mode parameters.
B.
Functions called in SQL statements cannot have out or in out mode parameters.
C.
Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
D.
Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.
B and D
B D
is A, B (talk of functions… no procedure)
A function also can take all 3 types of parameters.
Refer:
http://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm
http://psoug.org/snippet/FUNCTIONS-with-parameters_871.htm
B,D
B, D
I’m no longer positive where you’re getting your information, but great topic. I must spend a while studying much more or working out more. Thanks for magnificent information I used to be searching for this info for my mission.|