Re: formatting numeric values
From: <mhr123_at_my-deja.com>
Date: Thu, 18 Jan 2001 15:05:37 GMT
Message-ID: <9470nr$787$1_at_nnrp1.deja.com>
Date: Thu, 18 Jan 2001 15:05:37 GMT
Message-ID: <9470nr$787$1_at_nnrp1.deja.com>
In article <946tk7$4b0$1_at_nnrp1.deja.com>,
dennishancy_at_eaton.com wrote:
> In SQL, I enter the following:
>
> select numericColumn from someTable;
>
> I want to display numericColumn with two decimal places.
>
> How do I do this? Thanks.
>
> Dennis Hancy
> Eaton Corporation
> Cleveland, OH
>
> Sent via Deja.com
Hi,
If by SQL you mean SQL*Plus, you can issue:
SQL> column numericColumn format 9999999990.00
regards, Michael Ringbo
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Thu Jan 18 2001 - 16:05:37 CET