title: Values are not displaying with leading zero in oracle
body: <p>I have a table where i have data with leading zeros for a column(<strong>number</strong> datatype). When i try to query the column in apex - SQL Workshop, it is not displaying the leading zero. So i need to manually convert to display value with leading zeros. But there is a problem while converting.</p>
  
  <p>If i format explicitly using <code>to_char</code> then it is affecting the normal value. 
  For example </p>
  
  <pre><code>select to_char(colA,'0.99') from tab1 
  </code></pre>
  
  <p>will give me <strong>0.87</strong> when value is .87 but we do have values without decimal also. in that case it will give me ###. Basically i want to display value as it is(but add 0 if value is starting with decimal). It should not add trailing zero also.Is there any way to achieve this? For example, below will give <strong>661.00</strong>. But it should not give. If it whole number, it should display the same value.</p>
  
  <pre><code>select to_char(661,'999G999G999G999G990D00MI') from dual 
  </code></pre>