title: What SQL would I need to use to list all the stored procedures on an Oracle database?
body: <p>What SQL would I need to use to list all the stored procedures on an Oracle database?</p>
  
  <p>If possible I'd like two queries:</p>
  
  <ol>
  <li>list all stored procedures by name</li>
  <li>list the code of a stored procedure, given a name</li>
  </ol>