title: sql : How is data validation done through Stored procedures?
body: <blockquote>
    <p>" Stored procedures are typically used for data validation or to 
    encapsulate large, complex processing instructions that combine several SQL queries."</p>
  </blockquote>
  
  <p>Says this Oracle <a href="http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767/procedures_plsql.htm" rel="nofollow">reference</a>. So can someone help me understand by putting in real world examples how stored procedures are used fro data validation ?</p>