title: plsql - get first row - which one is better?
body: <pre><code>LV_id number;
  Cursor CR_test Is
    select t.id
    from table1 t
    where t.foo = p_foo
    order by t.creation_date; 
  
  Open CR_test;
  Fetch CR_test
   Into LV_id;
  Close CR_test;
  </code></pre>
  
  <p>or this one :</p>
  
  <pre><code>select x.id
  from(select t.id
       from table1 t
       where t.foo=p_foo
       order by t.creation_date) x
  where rownum = 1
  </code></pre>
  
  <p>Both above make similar result but i need known about which one is more efficient!</p>