Oracle does not support the ANSI 92 join syntax, at least through version
7.3.x I am unsure about 8. The outer join syntax is also different, Oracle
uses a (+) to signify outer joins. Oracle supports both left and right
outer joins but not double outer joins.
Franklin <sbecker_at_shaw.wave.ca> wrote in message
news:7db5m5$jlu$1_at_pugsley.tor.metronet.ca...
> We are working on an application that is using MS SQL Server 6.5 as a
> dataserver right now. Our intentions are to make it Oracle compliant
> as the software will be commercial and will be required to run on an
> Oracle server. My question is:
>
> How are joins performed in oracle? Currently, I am using ANSI 92
> standard (ie: itemdetail i inner join itemdetailxrefreqdetail ix)
>
> Does Oracle 8.0 support this join? Does it support "*=" or "+="
>
> TIA
>
> Scott Becker (scott.becker_at_veco.com)
> Programmer/Analysist
> VECO Engineering
> Calgary, AB, Canada
> 403-218-4502
>
Received on Wed Mar 24 1999 - 12:47:11 CST
