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!

Displaying amt with 3 decimal points

745924Feb 9 2010 — edited Feb 9 2010

Hi,

I have a column amt of datatype number.

Sample values - 1000, 1000.12, 1456.124,1234.2346

How do I display the amt with 3 decimal points.

ie, 1000.000, 1000.120, 1456.124,1234.234

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2010

Added on Feb 9 2010

5 comments

688 views