InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
In What Order Should A Open/fetch/loop Set Of Commands In A Pl/sql Block Be Implemented If You Use The %notfound Cursor Variable In The Exit When Statement? Why? |
|
Answer» OPEN then FETCH then LOOP followed by the EXIT when. If not specified in this ORDER will result in the final RETURN being done twice because of the way the %NOTFOUND is handled by PL/SQL. OPEN then FETCH then LOOP followed by the exit when. If not specified in this order will result in the final return being done twice because of the way the %NOTFOUND is handled by PL/SQL. |
|