Link to home
Start Free TrialLog in
Avatar of Amirl
Amirl

asked on

ANSI SQL92 Syntax

I'm looking for the ansi sql92 syntax in order to maintain
the same code for Oracle & Sybase & Informix

Thanks
Amir
ASKER CERTIFIED SOLUTION
Avatar of mshaikh
mshaikh
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image
I don't have the answer you asked for, but if you are deploying or planning to deploy an application with SQL code that is generic enough to work on these three databases, be aware that you will not get the performance you can get by optimizing the code for one database.
Avatar of Amirl
Amirl

ASKER

I'm looking for a site that has this reference on-line. My main concern is about stored procedures.

Thanks,

Amir
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image
My understanding is that the syntax for stored procedures is database-specific, meaning that the major database vendors DO NOT follow standards for this, rather each vendor has gone its own way in this area.
Avatar of mshaikh
mshaikh
Store procedures are quite database specific. Although, there is a SQL-92 standard for writing store procedure, Oracle does not conform to those standards! That would be too easy!
Avatar of mshaikh
mshaikh
I am not sure if Sybase and Informix do either!