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!

Number column in table not showing decimal points.

573274May 18 2010 — edited May 18 2010
Hi,

I am using Oracle-10g. I have a table in which there is an amount column with number(10,2). I am doing a calculation through a procedure and inserting rows into the table. All the values are round figures so they are being inserted as 0,1125,1800 instead of 0.00,1125.00,1800.00. How can I make the values to show as 0.00, 25.00 etc in the table instead of rounding the numbers.

Thanks in advance,


Raj Naraparaju.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2010
Added on May 18 2010
10 comments
29,722 views