Just like Multi-table insert(using INSERT ALL) is there multi-table Update facility in Oracle? In which version?
Asked
Active
Viewed 739 times
0
-
You want to update multiple tables with one statement OR within one transaction ? – Yahia Nov 03 '11 at 06:21
-
Yes, a single sql should be able to update multiple tables. – Plymouth Rock Nov 08 '11 at 06:34
1 Answers
1
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...
Yahia
- 69,653
- 9
- 115
- 144