Oracle plsql how to check if number has decimal points
<p>Just started working with oracle using toad ide. trying to format the numbers from a table in specific format. the numbers come in from a variable in the table and I want to display the whole numbers as whole numbers and display floats as floats. So far, I can use <code>trim(TO_CHAR (width,'999.999'))</code> to display all numbers with decimal points.</p>
<p>For example: 123.5 will be displayed as 123.500 and 100 will be displayed as 100.000.</p>
<p>What I want to do is display for eg: 100 as 100.</p>
<p>Hope this is clear and I get a solution soon.</p>