title: How to View Oracle Stored Procedure using SQLPlus?
body: <p>How can I view the code of a stored procedure using sqlplus for Oracle 10g?</p>
  
  <p>When I type in:</p>
  
  <pre><code>desc daily_update; 
  </code></pre>
  
  <p>it shows me the parameter, but when I try to do the following:</p>
  
  <pre><code>select * from all_source where name = 'daily_update';
  </code></pre>
  
  <p>I get </p>
  
  <blockquote>
    <p>no rows selected</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>