Hi All

In a cursor using pessimistic locking i would like to know what is
the essential difference when

cursor c is select * from emp for update;

and

cursor c is select * from emp for update of sal;

If there are no column level locks in Oracle . How are the 2
statements different. To ellaborate what different things can
i carry out after i open the cursor in one case which i cannot
in another.

even if i say for update of sal i can update other column values inside the loop of the cursor.
So whats the difference.

Kindly Respond

Regards
Sushant