Re: formatting numeric values

From: Myron Wintonyk <mwintony_at_med.ualberta.ca>
Date: Fri, 19 Jan 2001 10:23:40 +1000
Message-ID: <3A67890C.4ADD0907_at_med.ualberta.ca>


[Quoted] [Quoted] You can use the to_char funciton. For example, to_char( salary, '999999.99' )
This works in SQL*Plus as well as other query tools such as Golden and TOAD. 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
> http://www.deja.com/
Received on Fri Jan 19 2001 - 01:23:40 CET

Original text of this message