-2

Here's an example.

enter image description here

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

Improve this question
2

1 Answer 1

Reset to default
0 
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;
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.