This forum is currently locked. You can't register or post questions at this time. (read more)

AnsI to oracle

All posts relating to Oracle database administration.

Moderator: Tim...

kaushik.nandy
Member
Posts: 43
Joined: Sun Oct 31, 2010 8:12 am

AnsI to oracle

Postby kaushik.nandy » Wed Sep 25, 2013 9:38 am

How can I convert this part of the ANSI Query to Oracle query..


LEFT JOIN GlobalAttribute GARate ON GARate.ParentKey = CaseName.CaseNameKey AND GARATE.PARENTTABLENAME = 'CASENAME' AND GARate.AttributeKey = 80400
LEFT JOIN GlobalAttribute GAMain ON GAMain.ParentKey = CaseName.CaseNameKey AND GAMain.PARENTTABLENAME = 'CASENAME' AND GAMain.AttributeKey = 80301

This is what I have done....

AND GARate.ParentKey(+) = CaseName.CaseNameKey
AND GAMain.ParentKey(+) = CaseName.CaseNameKey
AND GARATE.PARENTTABLENAME(+) = 'CASENAME'
AND GAMain.PARENTTABLENAME(+) = 'CASENAME'
AND GARate.AttributeKey(+) = 80400
AND GAMain.AttributeKey(+) = 80301


Please let me know if the conversion is correct ??

Thanks

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: AnsI to oracle

Postby Tim... » Wed Sep 25, 2013 4:07 pm

Hi.

Why would you convert it? Oracle supports ANSI Joins.

http://www.oracle-base.com/articles/9i/ ... upport.php

Personally, I always write ANSI SQL these days. I don't think I've used the old style syntax since Oracle 9i.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron