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!

decimals in data value in SQL

998158Jun 25 2013 — edited Jun 27 2013

Hi,

I have data column defined as Balance NUMBER(20,6) in my table. The data that I'm loading is 2500.44634. But, when I see in table, I see data coming as 2500.4. No matter how many decimals I give in datatype, table is displaying only one deimal value. Do I have to change settings anywhere to display complete decimals as I have in my original data

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2013

Added on Jun 25 2013

13 comments

1,738 views