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

rolympia_at_hotmail.com (Romeo Olympia) wrote in message news:<42fc55dc.0405130133.6401dc08_at_posting.google.com>...
> 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.

I am not able to find anywhere Oracle's extensions to standard SQL...they reference it on tahiti and in their docs but only mention 2 sentences on the subject - where can I find a complete list of these extensions ?? At least the major ones !?

thanks
Jack Received on Thu May 13 2004 - 21:12:22 CEST