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

[Jack]

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

[Hans Forbrich]

Jack wrote:

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..

For the life of me, I can't remember the ANSI syntax for 'CONNECT BY'.

[Romeo Olympia]

ja***********@yahoo.com (Jack) wrote in message news:<20**************************@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.

[Jack]

ro******@hotmail.com (Romeo Olympia) wrote in message news:<42**************************@posting.google. com>...

ja***********@yahoo.com (Jack) wrote in message news:<20**************************@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