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!

Identify Precision of value or column

7d317efd-22e8-4dc0-aacc-0c403c5620beSep 15 2016 — edited Sep 16 2016

I have table already with lot of data, it has column called 'Amount' and datatype is number.

it has values like (for example)

6.47406190350509E15

9.2887386559616E15

I am trying to convert datatype to number with precision and scale. How do I identify the precision and scale of existing values?

I have tried querying all_columns table but it has nothing in it.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2016

Added on Sep 15 2016

8 comments

2,309 views