title: difference between out parameter and returned value in pl/sql
body: <p>My understanding is there are 2 ways of returning retult from a procedure or function,</p>
  
  <ol>
  <li><p>OUT type parameter: this is used to get values from procedures and functions</p></li>
  <li><p>returned value from a function,</p></li>
  </ol>
  
  <p>My question is, </p>
  
  <ol>
  <li><p>what is the different between OUT parameter and returned value in a function?</p></li>
  <li><p>If I have a OUT parameter in a function, does it mean I can have 2 "returned" result?</p></li>
  </ol>