0 votes
in PL/SQL by
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?

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Mar 10, 2021 in PL/SQL by sharadyadav1986
0 votes
asked Mar 8, 2021 in PL/SQL by sharadyadav1986
...