Skip to Main Content

Oracle Database Discussions

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!

Converting Oracle SQL to ANSI SQL?

user957328Dec 14 2016 — edited Jan 18 2017

Can someone help me understand how to convert the following update statement to ANSI SQL?

I'm not sure how to do a join in an update statement with a table in a subquery.

update table1 a

set col1 = 'AAA'

where exists (   select 1

                         from table2 b

                         where b.col2 = a.col2 );

Thanks for your advice.

Steve

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2017
Added on Dec 14 2016
4 comments
1,509 views