Re: Get Count of Decimal Places
From: Doug Miller <spambait_at_milmac.com>
Date: Thu, 13 Mar 2008 18:12:20 GMT
Message-ID: <88eCj.27425$J41.7460@newssvr14.news.prodigy.net>
Date: Thu, 13 Mar 2008 18:12:20 GMT
Message-ID: <88eCj.27425$J41.7460@newssvr14.news.prodigy.net>
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:
>
>..050485436893203883495145631
>234.040388349514563106796116505
>
>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