Oracle PL-SQL Question:

What will happen after commit statement?

Tweet Share WhatsApp

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.

Download Oracle PL-SQL PDF Read All 52 Oracle PL-SQL Questions
Previous QuestionNext Question
Can we declare a column having number data type and its scale is larger than pricesion
ex: column_name NUMBER(10,100),
column_name NUMBAER(10,-84)
Explain the usage of WHERE CURRENT OF clause in cursors?