Re: Help! Oracle from SQLServer

From: Ron Reidy <rereidy_at_uswest.net>
Date: Sun, 06 Jun 1999 23:00:11 -0600
Message-ID: <375B51DB.771E19A1@uswest.net>

jkanel_at_productivesystems.com wrote:

> I am attempting to create an ActiveX EXE that links to a dabase through
> ODBC. The database specifications will always be the same but my SQL syntax
> does not work the same for SQLServer as it does for Oracle. Could someone
> please tell me:
>
> 1. How do I represent a date in Oracle-SQL (e.g. SQLServer-SQL is
> #6/4/99 4:05 PM#)
> 2. Is there a universal outer join operator?
>
> Doesn't Oracle support ANSI SQL-92? Please help - this is frustrating!
>
> Jeff Kanel
> Productive Systems, Inc.
> jkanel_at_productivesystems.com

Yes, Oracle is ANSI SQL-92 compliant.

Did you read any of the docs? Look at the SQL Reference Guide.

--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C. Received on Mon Jun 07 1999 - 00:00:11 CDT