This content has been marked as final. Show 2 replies
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.
Here the joining condition goes in the WHERE clause.
select e.* from emp e, dept d where e.deptno = d.deptno
With ANSI SQL format its like this.
Here the join condition is mentioned separately and not in WHERE clause.
select e.* from emp e join dept d on e.deptno = d.deptno
Oracle supports ANSI SQL starting from 9i version.
You can read more about the syntax difference Here