title: when should I go for procedure or function in PL/SQL?
body: <p>I am new in PL/SQL trying some practice examples.<br />I have few questions regarding PL/SQL <code>PROCEDURE</code> &amp; <code>FUNCTION</code>:</p>
  
  <p>When should I go for the <code>PROCEDURE</code> or <code>FUNCTION?</code></p>
  
  <p>Means, whatever task I am doing using <code>FUNCTION</code> the same task will do by using <code>PROCEDURE</code>.
  then why should I go for the function? is their any advantage of <code>FUNCTION</code> over the <code>PROCEDURE</code> in PL/SQL? </p>
  
  <p><code>FUNCTION</code> must return value. Is this the only advantage for using a function or are there any other advantages of functions?</p>