Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Oracle from SQLServer

Re: Help! Oracle from SQLServer

From: Örjan Lundberg <orjanlundberg_at_my-dejanews.com>
Date: Tue, 8 Jun 1999 23:35:13 +0200
Message-ID: <7jk2bh$bui$1@news.luth.se>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US