RPAD to Decimal value
551966Apr 9 2009 — edited Apr 9 2009Hi,
i have created following table and number data type have following values.
create table abc(n number);
select * from abc
n
---
0.24
0.55
1.265
I want this value with right side padded with 10 length.
if i m using this query select rpad(to_char(n),10,' ') from abc it is omitted 0. from left side and gives value like .2
Please help me.
Thanks in advance.