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 of digits/decimals in a number

588770Jul 27 2010 — edited Feb 25 2013

Hello,

how can I (with sql or plsql) get the number of digits in total in a number and the amount of decimals?

So if I have 1234 I have 4 digits and 0 decimals. 1234,123 I have 7 digits and 3 decimals.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2013

Added on Jul 27 2010

11 comments

71,930 views