| Header 1 | Header 2 |
|---|
| 1 | .3 |
| 1 | 5.48 |
| 1 | 4 |
| 1 | 1555.1 |
Dear All,
In a table i have a data like above table.
I want output like (ratio)
1:0.30
1:5.48
1:4.00
1:1555.10
When i am giving To_char(abc_num,'0D00') then first three rows are coming fine but last row comming like 1:#####.
when i am giving To_char(abc_num,'0000D00')
1:0000.30
1.0005.48
which i don't like. Could you please tell me how can i achive
1:0.30
1:5.48
1:4.00
1:1555.10
Regards
Rajat