Update multiple columns using values from different tables

Question

Here's an example.

I want to update Table1 where Address IS NULL to the format State: Zip in 1 single update statement as this table probably has 10k rows. In Oracle

Answer 1

BEGIN
For i in (select id, name, zip from table2) 
LOOP
Update table1 set address = state ||': '|| i.zip where id = i.id and 
address is null;
END LOOP;
END;