1.

What Will Happen After Commit Statement ?

Answer»

Answer : 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 EVEN after COMMIT/ROLLBACK.

 

The cursor having query as SELECT .... FOR UPDATE gets closed after COMMIT/ROLLBACK.
The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

 


Discussion

No Comment Found

Related InterviewSolutions