What will happen after commit statement?
Submitted by: AdministratorCursor 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle PL-SQL Job Interview Questions And Answers
Top Oracle PL-SQL Questions
| ☺ | Explian rowid, rownum?what are the psoducolumns we have? |
| ☺ | what is the starting oracle error number? |
| ☺ | What is difference b/w stored procedures and application procedures, stored function and application function? |
| ☺ | In a Distributed Database System Can we execute two queries simultaneously? Justify? |
| ☺ | Name the tables where characteristics of Package, procedure and functions are stored? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
