title: AutoTrace in sql Developer
body: <p>What is the basic difference between EXPLAIN PLAN and AUTOTRACE 
  in SQL Developer. Can anybody please elaborate? </p>
  
  <p>This is the query on which I am trying to get the difference inbetween Autotrace 
  and Explain Plan.</p>
  
  <pre><code>SELECT name, address, latest_in
    FROM ( SELECT name, address, latest_in
           ROW_NUMBER() OVER (PARTITION BY name ORDER BY address DESC) AS rowrank    
           FROM avrajit
         )
    WHERE rowrank &lt;&gt; 1 AND rowrank &gt; 3;
  </code></pre>