show zeros after the decimal point
572758Jun 5 2007 — edited Jun 5 2007I 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