Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

update query performance

raviavanchaApr 18 2018 — edited Apr 20 2018

Hi,

I have a scenario where i need to update few columns in table A from table B and table C.The problem is there is no relation between tables B & C. Following is the query in SQL server:

Update A set A.column1 = B.column1,

A.COLUMN2 = C.column2

From

tableA  A

inner join

tableB B on  (join condition)

inner join

tableC C on (join condition);

I don't want to prepare separate updates for both the tables. I've read in few forums that oracle update doesn't support joins and the only work around is using merge. Also I don't want to prepare a sub query or a temp table by joining tables A,B & C. Any help in this regard would be appreciated.

This post has been answered by L. Fernigrini on Apr 18 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2018
Added on Apr 18 2018
2 comments
433 views