we are using oracle 11g 2, windows os. SQL developer.
I am trying to write a pl sql or stored procedure that needs to declare two cursors.
Just wondering the syntax about begin end
declare Cursor c1 is
select....;
Cursor c12 is
select....;
Begin
Begin
For rec in c1
Loop
.....
End loop;
End ;
Begin
For rec in c2
Loop...
End loop;
End;
End;
do I need a begin end for each cursor for loop, like I added in red. Or I don't need the red - begin end .
Thanks,