Re: using decimal points in oracle

Nicholas Mudie,

Please ensure that the data type for the column is number(16,2) or something like that where 2 represents two decimal places.

Alternatively, you can ROUND the value to 2 decimal places.

cheers
- Ram

Nicholas Mudie wrote:

> Hi Everyone,
>
> I have a column in my database which displays information like this:
>
> 312.200463260440213486618344769832761638
> 71.84514585513286835742982511836200263337
> 54.88363435721267112681207905366965929238
> and so on..........
>
> I want to show this value to the max of two decimal places. (i.e 54.88 ) How
> would I do this??
>
> I display the oracle data using cgi scripts and call an embedded SQL
> statement like this:
>
> $getfactor = $dbh->prepare(qq{select customer_id, pkg, p_domain, network,
> country, bytes, factor from _at_tablename WHERE factor > '$fa
> ctor%' and pkg like '%$sqlpkg%' and p_domain like '%$sqldom%' and network
> like '%network%' order by bytes desc});
>
> If I know the oracle command to take these values to two decimal places I
> could use it in the above statement.
>
> Many thanks,
> Nick
>
> Applications Engineer
> Chello Broadband
> Amsterdam
> Holland
>
> 0611012214
Received on Tue Aug 07 2001 - 06:40:18 CEST