Which two guidelines should be considered when designing and using cursors in a PL/SQL
block? (Choose two.)
A.
When fetching from a cursor, fetch into a record.
B.
When fetching from a cursor, fetch required values into individually declared variables.
C.
Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE
statements to manipulate the cursor instead of using the cursor FOR loop.
D.
Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and
using the OPEN, FETCH, and CLOSE statements to manipulate the cursor.
Always a major fan of linking to bloggers that I adore but dont get a great deal of link love from.
A, D