Which two statements are correct about the usage of parameters in functions?

Which two statements are correct about the usage of parameters in functions? (Choose two.)

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 outmode 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.

Show Hint

Leave a Reply 8

Your email address will not be published. Required fields are marked *

Alisa

Alisa

In SQL (not PL SQL),
Functions called cannot have out or in out mode parameters.

Reply

WR

WR

For example: The syntax for the CONCAT function in SQL is:

CONCAT( string1, string2 )

This function can only have in parameters in SQL only, it cannot have out or in out mode parameters in SQL (not PL SQL)

Reply