Re: support for "Inner Join", "Outer Join" etc...

If you are using ODBC/OLE DB as a data provider for your app I think that your best bet is to try to use ODBC escape syntax. (email me and i will send you an ODBC.hlp file if you wish for reading). This escape syntax allows to run the same SQL to query both Oracle/SQL Server databases and makes the ODBC driver perform the necessary translation to convert your SQL string into a DB compliant SQL string. This is also need for, say, scalar functions such as Len(<MyString>) since Orcacle syntax is, once again, different.

Oracle does not support the OUTER JOIN syntax that SQL server does. When creating views it also does not support INNER JOIN syntax (you must user T1.F1 = T2.F2 SQL instead!)

if you are only performing basic select statements you should be OK but beware:
ORACLE does not support updateable views like SQL Server does (it only allows you to update 'Key Preserved Views' see ORACLE documentation). Thus you must update the underlying table of more 'complex' views. Security works differently, and data types are different.

It's a big job to port your application so do not under estimate the time that it will take!

Julian Received on Wed Mar 24 1999 - 11:25:05 CST