Which guidelines should be considered when designing and using cursors in a PL/SQL block? ?

Which guidelines should be considered when designing and using cursors in a PL/SQL block? ?
(Choose all that apply.)

Which guidelines should be considered when designing and using cursors in a PL/SQL block? ?
(Choose all that apply.)

A.
When fetching from a cursor, fetch into a record.

B.
Use parameters with cursors so that the result set for the cursor is not tied to a specific
variable in a program.

C.
Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for
non existent values.

D.
Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE
statements to manipulate the cursor instead of using cursor FOR loop.

E.
When using data manipulation language statements, (DML) reference a SQL cursor attribute
immediately after the DML statement executes in the same block.



Leave a Reply 2

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