Skip to Main Content
Forums

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!

How to convert this old Oracle style SQL to ANSI SQL ?

York35Feb 17 2017 — edited Feb 27 2017

Oracle DB version:11.2.0.4

I want to convert the following to ANSI SQL .

SELECT ASTXA.sku_val

  FROM   s_asset_xa ASTXA,

         s_asset ASSET,

         s_prod_int PRD

  WHERE 

  ASSET.row_id = ASTXA.asset_id(+)

  AND ASSET.prod_id = PRD.row_id(+)

  AND PRD.fulflmnt_item_code = '318XA'

  AND ASTXA.attr_flag = 'NMD'

I have around 20 big SQLs which I need to convert to ANSI SQL . Are there any easy tricks that I can follow to convert the old Oracle Style joins to ANSI joins ?
This post has been answered by BluShadow on Feb 17 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2017
Added on Feb 17 2017
21 comments
3,482 views