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!

What is the max precision and scale can NUMBER type column store?

user9163886Oct 12 2016 — edited Oct 13 2016

Hi,

We have a situation to store very big amounts in NUMBER type column in database (length 50 of a number). We are able to insert the data but when we try to select the value we are getting with exponential character like mentioned below.

Number

-----------------------------

1.23456789012135E15

but we would like to display 1234567890121345.56

Thanks!

Naga

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2016

Added on Oct 12 2016

4 comments

4,963 views