title: Difference between 'Execute' and 'Execute as script'
body: <p>I'm currently experiencing what I believe is strange behavior when using Oracle with TOAD. </p>
  
  <p>I have a query:</p>
  
  <pre><code>SELECT
       COUNT(as_at_date)
  FROM
       job_log
  WHERE
       as_at_date = TO_DATE('24/11/2009', 'dd/mm/yyyy'); 
  </code></pre>
  
  <p>When I try to run this using Toads 'Execute statement' button I get zero rows returned. However when I use 'Execute as script' I get one row returned, which is as expected.</p>
  
  <p>Can anyone explain to me why using the different commands would produce differences in the result set?</p>
  
  <p>Thanks.</p>