Re: Get Count of Decimal Places
Date: Thu, 13 Mar 2008 18:12:20 GMT
In article <9d7175d8-b656-40f7-bf30-1024ca1396a3_at_d62g2000hsf.googlegroups.com>, webtourist <webtourist_at_gmail.com> wrote:
>I have some number data in table like this:
>i.e. very large decimal places..
>I'd like to update them and ROUND them all to 8th decimal.
>How to get the number of decimal places ? or I have to do this via
>to_char, substr etc....
If you're going to round them all to the 8th decimal anyway, why do you care how many decimal places there are before rounding? Received on Thu Mar 13 2008 - 13:12:20 CDT