question

OraLearner avatar image
OraLearner asked

Can we update multiple tables with a single query ?

Can anybody explain me with an example that if we can update multiple tables with a single query? Thank you.

queryoracletable
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image HillbillyToad commented ·
What's your business problem? If you can give us an idea of the challenge, we can formulate an answer in terms of SQL or PL/SQL...
1 Like 1 ·

1 Answer

·
Andrew Mobbs avatar image
Andrew Mobbs answered

Not directly, but if the update fires a trigger, code in that trigger might update other tables.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KillerDBA avatar image KillerDBA commented ·
I would suppose you could also use a function with side effects. Probably a pretty bad idea, though.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.