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 characters needed characters left characters exceeded

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

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

· Write an 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 characters needed characters left characters exceeded

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

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.