Is it possible to select a dataset using a cursor and then update a column within that dataset to a different numerical value within the cursor, before re-updating another table with the altered values in the dataset of the cursor???
for example if the cursor was defined as:
Cursor c_xyz is select * from opp_project
can you now do an update like:
UPDATE c_xyz.column_name SET = 2 (or whatever)
before doing a permanent update to another table using the altered cursor dataset??
Yes, you can update through cursors. You need to slightly change the cursor declaration :
Cursor c_xyz is select * from opp_project for update of column_name;
Afterwards, the following statement should do the trick :
Update opp_project set column_name = 2
WHERE CURRENT OF c_XYZ
As you can see, the update is done on table opp_project using the actual "position" of cursor c. Hence, you can consider this change to be "permanent" to table opp_project in case you need it for further usage.