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!

Getting precision length for float data type

633928Apr 14 2008 — edited Apr 14 2008

Hi All,

We trying to find the precision length of a float (126) data type. Are there any built in functions in oracle for finding the same? E.g: the function should return 5 for the value 1.23456 .

Also, are there any table level operation to reduce the decimal precision of a float 126 field?

Regards,
Raj.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2008

Added on Apr 14 2008

2 comments

427 views