open/fetch/loop in hiring questions

open/fetch/loop in hiring questions

 

  

Hey gang-

The recent flurry of me toos on the hiring questions inspired me to go through them. Does anyone have an example I can play with to see the answer to #7 in action? My brain just isn't wrapping around it today. In case you don't have a copy, question #7 is:

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?

Thanx,

ltg

Oracle LazyDBA home page