Re: What Oracle SQL syntax does Oracle have that is not ANSI SQL ?

jack_posemsky_at_yahoo.com (Jack) wrote in message news:<209b7e58.0405121548.48544b26_at_posting.google.com>...
> Hi I am just trying to get a feel for what oracle SQL syntax there is
> that would not be covered at all in anyway from a functionality
> perspective in the standard ANSI SQL..
>
> Any input is appreciated..
>
> Thank you,
>
> Jack

An appendix in the SQL Reference document contains information regarding ANSI/ISO compliance. You might wanna check that out.

Also, you could test for compliance of any particular SQL statement you have by turning on FIPS flagging by using:

in sqlplus:
set flagger {off|entry|intermediate|full}

or

alter session set flagger

Any non-compliant construct will raise an error when this is turned on.

Hope that helps. Received on Thu May 13 2004 - 11:33:17 CEST