CODEWITHSUNDEEP
multi-table
Plymouth Rock
Plymouth Rock

Reputation: 492

Multi-table Update in Oracle

Just like Multi-table insert(using INSERT ALL) is there multi-table Update facility in Oracle? In which version?

Upvotes: 0

Views: 744

Answers (1)

Yahia
Yahia

Reputation: 70369

AFAIK there is no such facility in Oracle - you can't UPDATE multiple tables within one statement - you can use mutiple tables within an UPDATE statement but only one table can be updated.

What you could do is either wrap multiple UPDATE statements into one transaction and/or use an INSTEAD OF trigger which in turn contains multiple UPDATE statements...

Upvotes: 1

Related Questions