Answers for "simple use of cursor in pl sql"

pl sql implicit cursor

FOR b IN (SELECT * 
              FROM sometable)
  LOOP
    <<do something   b.somevalue>>
  END LOOP;

Posted by: Guest on May-25-2021

for cursor plsql

FOR record_name IN cursor_name
LOOP 
	statement1; 
	statement2; 
	. . . 
END LOOP;

Posted by: Guest on March-09-2020

Code answers related to "simple use of cursor in pl sql"