Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Oracle from SQLServer
1 and 2 : Use the ODBC escape functions { oj ... } for the outer joins and
{t ...} ( I think) for dates
see this Microsoft whitepaper for an explanation :
http://www.microsoft.com/sql/70/whpprs/orcltosql.htm
2. No Oracle does not support the ANSI-92 JOIN syntax (as of Oracle 8.1.5). Oracle has full compliance at the SQL-92 Entry level, and some points of compliance at the Transitional, Intermediate and Full levels. Almost no database supports all levels of SQL 92 today (NCR Teradata ?). For example the ANSI concaternation operator "||" is supported by oracle but not by Microsoft SQL Server 7 which uses the "+" sign.
Örjan Lundberg Received on Tue Jun 08 1999 - 16:35:13 CDT