By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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'.
Jul 19 '05 #2

P: n/a
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.
Jul 19 '05 #3

P: n/a
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.