Skip to Main Content

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!

show zeros after the decimal point

572758Jun 5 2007 — edited Jun 5 2007
I have two fileds on a table

TOTAL_EST NUMBER(14,2)
TOTAL_PAID NUMBER(14,2)

when i get the results I get numbers without the zeros after the decimal
ex:
TOTAL_EST 50 52.01 508
TOTAL_PAID 30.2 30 600


What I want as a result is

TOTAL_EST 50.00 52.01 508.00
TOTAL_PAID 30.20 30 .00 600.00

How do I do that?

thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2007
Added on Jun 5 2007
10 comments
2,418 views