Oracle PL-SQL Interview Question:

What will the Output for this Coding>
Declare
Cursor c1 is select * from emp FORUPDATE;
Z c1%rowtype;
Begin
Open C1;
Fetch c1 into Z;
Commit;
Fetch c1 in to Z;
end;

Submitted by: Administrator

By declaring this cursor we can update the table emp through z,means wo not need to write table name for updation,it may be only by "z".

By issuing the TCL like commit or rollback, the cursor will be closed automatically, you cannat fetch again. You will get an error if yuo
Submitted by: Administrator