In oracle, without using a cursor, by directly using the for loop it can be done for multiple records to update multiple tables. One doesn't need to write a c# code for this.
BEGIN
FOR c IN
(
select distinct t2.name,t1.id
from table1 t1,
table2 t2
where t1.id = t2.id
)
LOOP
update table1 set name = c.name
where id = c.id;
END LOOP;
END;