Organizational Research By

Surprising Reserch Topic

difference between fetch for to loop a cursor in pl sql


difference between fetch for to loop a cursor in pl sql  using -'sql,oracle,plsql,cursor'

I know that fetching a cursor will give me access to variables like %ROWCOUNT, %ROWTYPE, %FOUND, %NOTFOUND, %ISOPEN

...but I was wondering if there are any other reasons to use

Open - Fetch - Close instructions to loop a cursor   

rather than

Loop the cursor with a FOR cycle... (In my opinion this is better becase it is simple)

What do you think?
    
asked Sep 9, 2015 by FranklynPROS
0 votes
22 views



Related Hot Questions



Government Jobs Opening


...