Oracle sql update with joins

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Add a comment. Active Oldest Votes. PHONE, c. FAX, p. Improve this answer. Daren Beattie Daren Beattie 34 1 1 bronze badge. Fixed the 1st one missing parentheses and added a 3rd way. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Active 2 days ago. Viewed 44 times. New contributor. MatBailie We didn't study that command in my course. Is there some other way? Add a comment. Active Oldest Votes. MatBailie MatBailie Add a comment. Active Oldest Votes. That syntax isn't valid in Oracle. NEW It depends if the inline view is considered updateable by Oracle To be updatable for the second statement depends on some rules listed here.

Tony Andrews Tony Andrews k 20 20 gold badges silver badges bronze badges. I did the second example but had to add aliases to the column names in the select and then reference them by their names in the SET but it worked, thanks — Gustavo Rubio.

The second example has the benefit of allowing you to test the SQL before actually performing the update. The second example worked for me. I like that one because it looks clean and readable. Don't know what the pros and cons are between the two when it comes to performance. But, I wasn't worried about that for now 'cuz I used this for a one off script to correct bad data.

Explanation on key-preserved requirement for updatable joins: asktom. Got this - "ORA cannot modify a column which maps to a non key-preserved table", and then stackoverflow. Show 7 more comments. Quassnoi Quassnoi k 88 88 gold badges silver badges bronze badges. Works perfectly but Oracle required me to say merge into table 1 t and so forth. Late to the party, but this is still a good thread. I need to know, tho' Master table, "table1". Table2, aliased as t2, but in the ON, the references are External Table1 - not t1 - is this a reference to the outer table or a type?

Not t2? Je suis confused. Fan of better aliases Just a point here, if your key trg.