Skip to Main Content
Forums

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!

default decimal places

Mohammed SardarOct 6 2014 — edited Oct 6 2014

Do we have any function to define how many default decimal places should be there in a field ?

I have defined this as Number(14,2). I want this to hold atleast two decimal places at all the time. not less that that. For example if I pass 4760.4 from the PL/SQL It should display in this  as 4760.00 always. If it's 4760.6 then it should be 4760.60 not 4760.6

any ideas please?

9974.4 should give me 9974.40.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2014
Added on Oct 6 2014
14 comments
3,671 views