Re: formatting numeric values
From: Greg Kainz <gregkainz_at_home.com>
Date: Sat, 20 Jan 2001 14:15:05 GMT
Message-ID: <J3ha6.77027$ge4.29193205_at_news2.rdc2.tx.home.com>
Date: Sat, 20 Jan 2001 14:15:05 GMT
Message-ID: <J3ha6.77027$ge4.29193205_at_news2.rdc2.tx.home.com>
[Quoted] and if the column was indexed, you just turned off the index access... :-(
"Myron Wintonyk" <mwintony_at_med.ualberta.ca> wrote in message
news:3A67890C.4ADD0907_at_med.ualberta.ca...
> 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 Sat Jan 20 2001 - 15:15:05 CET