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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jack
    #1

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

    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
    Tags: None
    • Hans Forbrich
      #2
      Re: What Oracle SQL syntax does Oracle have that is not ANSI SQL ?

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


        Comment

        • Romeo Olympia
          #3
          Re: What Oracle SQL syntax does Oracle have that is not ANSI SQL ?

          jack_posemsky@y ahoo.com (Jack) wrote in message news:<209b7e58. 0405121548.4854 4b26@posting.go ogle.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|inte rmediate|full}

          or

          alter session set flagger

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

          Hope that helps.

            Comment

            • Jack
              #4
              Re: What Oracle SQL syntax does Oracle have that is not ANSI SQL ?

              rolympia@hotmai l.com (Romeo Olympia) wrote in message news:<42fc55dc. 0405130133.6401 dc08@posting.go ogle.com>...
              jack_posemsky@y ahoo.com (Jack) wrote in message news:<209b7e58. 0405121548.4854 4b26@posting.go ogle.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|inte rmediate|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

                Comment

                Previous template Next
                Working...