Oracle Forms

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!

Help with TO_CHAR, formatting numbers for a report

446714Oct 26 2005 — edited Oct 29 2005

Hi, I use a view to provide data to a report. Currently I am using TO_CHAR for some columns in the view to format the numbers, however it's not coming out perfectly. I am using commands like:
..., TO_CHAR(sample_weight,'990.00'),...
However the numbers are coming out like:
138.05
94.45
1.34
etc... i want the decimal points to line up. Is there some way to force leading blanks at the beginning if the number isn't long enuff? I don't want to force leading 0's cos it would look silly.

thx
adam

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2005

Added on Oct 26 2005

#forms, #moved-from-devops

6 comments

822 views