title: How to add leading zero in a number in Oracle SQL query?
body: <p>I am retrieving a column named removal_count in my query using COUNT() function. In result set the datatype of removal_count is BIGDECIMAL. I want to convert number into five digits. SO if value is less than five digits then it should be represented with leading zero's.</p>
  
  <p>e.g 1) If removal count is 540 then display 00540<br>
      2) If removal count is 60 then display  00060</p>
  
  <p>If the removal count is integer/string value then I can add leading zero's using java expression :</p>
  
  <pre><code>--if removal_count is integer--
  String.format("%05d",removal_count)
  
  --if removal_count is string--
  ("00000"+removal_count).subString(removal_count.length())
  </code></pre>
  
  <p>Can we convert removal_count into string or integer ( from big decimal) so that I can use given java expression? Or else is there any way to add leading zero's in query itself?</p>