SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to show char 0.123 instead of .123

533682Dec 21 2006 — edited Dec 21 2006

Hi all,
Anyone else have a solution about my problem here?
select trim(to_char(.98, '999,999,999,999.999999')) from dual

Oracle may return you .980000 instead of 0.980000. For your info, I need a data return as string instead of number.

p/s: select trim(to_char(9.98, '999,999,999,999.999999')) from dual
There is no problem if my number > 0

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2007

Added on Dec 21 2006

3 comments

437 views