asked on

Oracle 9.2.05 bug with INNER JOIN ANSI?

Hi,

I'm working on a medium size project and have recently deployed the code to our client. When work began we agreed on Oracle 9.2.0.1 as the version and all my SQL statements work fine with this version. Now I drop the code to an Oracle 9.2.0.5 flavor of the database and by queries start having lots of problems.

The DBA there told me that INNER JOIN and LEFT OUTER JOIN ANSI queries will fail in 9.2.0.5.

My question is: Is this true? If so, not being a big PL/SQL expert, what can I replace the INNER JOIN AND LEFT OUTER JOIN keywords with? I need to fix this fast!

Thanks!

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

jrb1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Pierrick LOUBIER

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rdytmire

ASKER

Ok.. got it for innner joins but what about POST oracle 9i notation...how to I replace LEFT OUTER JOIN notation? I tried the (+) symbol in a test query here and no luck, appears to work just like a INNER JOIN.

rdytmire

ASKER

Thanks folks while the (+) syntax never did work correctly I finally was moved to accept ploubier's answer. I will ask the data center to upgrade to 9.2.0.6 rather than try to modify 50K lines of source code. :-)