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!

How to keep the zero after decimal

784597Mar 23 2011 — edited Mar 24 2011
Hi,

I'm trying to store numbers into one of the custom table column. This column must contain unique value for each record.
Now the issue is if i want to insert a record with zero after decimal point its removing that zero.
Emp Id (number)
1234.1
1234.2
...
...
1234.9
1234.10 --> 1234.1 (this is what is getting stored in table)
1234.11
...
I want to store 1234.10 not 1234.1, is there any way that i can store zeros as well after decimal point for NUMBER data type column.

Thanks in advance,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 23 2011
16 comments
13,818 views