2 Replies Latest reply: Dec 18, 2008 1:31 AM by William Robertson RSS

    what is Difference between ANSI SQL and ORACLE SQL

    664849
      Hi,

      I am going to take the assesment test for ANSI SQL Programming before that i want to know any difference between ANSI SQL and ORACLE SQL?

      I am studying for SQL but the test will be ANSI SQL please let me give an idea about the both.

      Thanks
      Merina Roslin
        • 1. Re: what is Difference between ANSI SQL and ORACLE SQL
          William Robertson
          ANSI is an industry standard. Some Oracle features are not ANSI compliant, either because they were added before the standard was defined (like DECODE) or because a commercial product like Oracle needs to be able to add new features (like MODEL).
          • 2. Re: what is Difference between ANSI SQL and ORACLE SQL
            _Karthick_
            Basically there is syntax difference between both of them.

            Lets say i want to join two table EMP and DEPT based on DEPTNO.

            With Oracle SQL format its like this.
            select e.*
              from emp e, dept d
             where e.deptno = d.deptno
            Here the joining condition goes in the WHERE clause.

            With ANSI SQL format its like this.
            select e.*
              from emp e
              join dept d
                on e.deptno = d.deptno
            Here the join condition is mentioned separately and not in WHERE clause.

            Oracle supports ANSI SQL starting from 9i version.

            You can read more about the syntax difference Here