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 Format in Oracle

PadmaOct 1 2011 — edited Oct 4 2011

Hi All

I have a requirement like this

1. In my Oracle database I have a column type Number(38,10)
2. According to user requirement I want to store the numbers like 12.450000 as it is.
When this number (12.450000) enters to the system it automatically converted to 12.45, but I still need the number user has entered

Ple any one tell me a solution for this

Thanks
padma

This post has been answered by BluShadow on Oct 3 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2011

Added on Oct 1 2011

16 comments

290 views