Oracle cursor usage

Use cursor to update data in Oracle

Declare cursor cur is select * from test for update;
Idnum number;
R test % rowtype;
Begin
Idnum: = 0;
Open cur;
Loop
Fetch cur into R;
Exit when cur % notfound;
Idnum: = idnum + 1;
Update Test Set ID = idnum where current of cur;
End loop;
Commit;
Close cur;
End;

Oracle multi-Table update

The GUID is associated with the ID of the TBB table. You need to update the name of the guid to the name of the TBB table.

Update
(
Select a. Name aname, B. Name bname
From b7-a, tbb B where a. ID = B. ID
)
Set aname = bname