Q. The DBMS_SQL package should be used in which of the following situations?
-
(A)
There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL statement.
-
(B)
The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable.
-
(C)
Both A & B
-
(D)
None of the above
✅ Correct Answer: (C)
Both A & B