Entries categorized as after commit statement
After commit statement
What will happen after commit statement ? Â Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;—– commit; end loop; end; The cursor having query as SELECT …. FOR UPDATE gets closed after COMMIT/ROLLBACK. The cursor having query as SELECT…. does not get closed Read More...