title: Oracle, adding leading zeros to string (not number)
body: <p>I am using Oracle (work space is TOAD) and I need to make my strings that if they are shorted then 10 characters then add leading zeros to make them all 10 digit strings.</p>
  
  <p>For example if I have a string like this: 
  '12H89' need to be '0000012H89' 
  or 
  '1234' to be '0000001234'</p>
  
  <p>How can this be done? Whats the best way?</p>
  
  <p>Thanks in advance .</p>