Can we update multiple tables in a single update query?

[Kaustubh G Sharma]

Can we update multiple tables in a single update query?

[Christophe Verré]

No. At least not in Oracle

[Bharath Raja]

Kaustubh G Sharma wrote:Can we update multiple tables in a single update query?

have you idea about triggers

[Kaustubh G Sharma]

Yes i know lil bit about triggers but never used it

[Matthew Brown]

Christophe Verré wrote:No. At least not in Oracle

But you can in MySQL. So it depends on your database.

[Kaustubh G Sharma]

Thanks .. Gotcha

[Martin Vajsar]

Christophe Verré wrote:No. At least not in Oracle

It is certainly possible in Oracle using key-preserved views ("updatable joins"). See what Tom Kyte has to say about it.

Then there is the multitable insert, which is usually used in ETL processing (read input data once and insert it into many tables, avoiding multiple full scans over external tables for example).

[Martin Vajsar]

Bharath Raja wrote:have you idea about triggers

Triggers may appear to be cool, but no, I wouldn't advise to use drivers. There is no execution order specified for triggers and once there are more than a handful of them, any troubleshooting is a nightmare.

Stored procedure would be much better way in this case, if someone wanted to implement the logic in the database.