Re: ANSI SQL92 question

From: Russ McTyre <rmctyre_at_solutionbuilders.com>
Date: Wed, 7 Oct 1998 07:34:08 -0400
Message-ID: <6vfjjv$b6v$1@camel19.mindspring.com>

Rob,

Thanks for the response. I know Oracle8 uses the (+) syntax for outer joins, but I was wondering if it also supported the ANSI 92 standard join syntax. I ask because I'm developing a database application that uses ODBC to attach to a myriad of databases, and so far, Oracle is the only one I've encountered that doesn't seem to support the ANSI 92 (INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN) syntax. Are there any settings that control this behavior on the server side?

Thanks,

Russ Received on Wed Oct 07 1998 - 06:34:08 CDT