DBMSSQL package used in different situations

Q.  PL/SQL: The DBMS_SQL package should be used in which of the following situations?
- Published on 24 Jun 15

a. 13. 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

ANSWER: Both A & B
 
The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL

Related Content

 

    Discussion

  • venkatesan   -Posted on 08 Feb 17
    welll

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲