Re: DB-independent SQL

In Oracle, you can use FIPS flagging to ensure that your SQL is compatible with SQL-92:
alter session set flagger=<entry or intermediate or full or off>;

<entry> for SQL92 entry level;
<intermediate> for SQL92 intermediate level;
<full> for SQL92 full level;
<off> to turn off the flagging.

Appendix B of Oracle SQL Reference: "Oracle and Standard SQL" gives you advices to write your SQL in a compatible way.

--
Have a nice day
Michel

Parker Sorenson <sparker_at_averstar.com> a écrit dans le message : 384590E6.E989EC60_at_averstar.com...
> Hello,
>
> Can somebody tell me what is the best way to go about writing all of
> your SQL statements so that they will be compatible with any DB server
> you use.
>
> i.e., I want to develop a DB application that is portable to different
> database systems. I do the porting of the interfaces... but, how do i
> ensure that the SQL statments plugged into those interfaces are
> "accepted" by the target DB?
>
> Is there a good resource for this somewhere?
>
> any help is very much appreciated
> -parker
>
Received on Thu Dec 02 1999 - 03:34:28 CST