Get Count of Decimal Places
From: webtourist <webtourist_at_gmail.com>
Date: Thu, 13 Mar 2008 10:55:18 -0700 (PDT)
Message-ID: <9d7175d8-b656-40f7-bf30-1024ca1396a3@d62g2000hsf.googlegroups.com>
Date: Thu, 13 Mar 2008 10:55:18 -0700 (PDT)
Message-ID: <9d7175d8-b656-40f7-bf30-1024ca1396a3@d62g2000hsf.googlegroups.com>
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....
thanks Received on Thu Mar 13 2008 - 12:55:18 CDT