display exact 3 decimal values
Hi,
It am unable to figure out how I can display 3 deimcal places of a number where two decimal values exist.
The following works fine using dual table.
For example
select to_char('43.73', '9999.999') from dual
O/P is 43.730
but when I get the values using procedure it display '43.73', I have tried to_char, to_number functions and no luck..........can anybod share function to display zero at the end. your help is appreciated.
The data type of the column is "varchar2(50)
Sonia