Oracle SQL Formatting
<p>Consider below set of column date in oracle:</p>

<pre><code>column_name
na
110000
440000
</code></pre>

<p>I want to achieve two things here</p>

<ol>
<li>Numbers should be in the format 99999.90</li>
<li>In output, word like na/NA should be replaced by blank or num field</li>
</ol>