Statements used to process multi-row query - SQL Operations

Q.  To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use?
- Published on 07 Jul 15

a. OPEN-FOR
b. FETCH
c. CLOSE
d. All mentioned above

ANSWER: All mentioned above
 
Dynamic SQL is used to create general purpose,flexible applications so that the full text may be unknown at compilation. Hence, To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), we use the OPEN-FOR,FETCH,CLOSE statements.

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