title: what is the difference between inner join and equi join in oracle and which of the following queries gives high performance?
body: <p>what is the difference between inner join and equi join in oracle and which of the following queries gives high performance?</p>
  
  <pre><code>select e.*,d.* 
  from emp e,dept d
  where d.DNAME='ACCOUNTING' and e.DEPTNO=d.DEPTNO --(equi join)
  
  select e.*,d.*
  from emp e
  inner join dept d on e.deptno=d.deptno 
  where d.dname='ACCOUNTING'; --(inner join)
  </code></pre>