Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Displaying NUMBER data

Re: Displaying NUMBER data

From: Yong Huang <yhuang_at_indigopool.com>
Date: Tue, 29 Aug 2000 13:58:51 -0500
Message-ID: <8oh1as$dhs$1@news.sinet.slb.com>

set numwidth 13

Yong Huang
yhuang_at_indigopool.com

<sergey_s_at_my-deja.com> wrote in message news:8ogqa5$lk6$1_at_nnrp1.deja.com...
> How do I display numbers fully expanded?
>
> For example, I have a column of type NUMBER(13) with values:
>
> NUMBER(13)
> ----------
> 8.4581E+11
> 8.4581E+11
>
> It seems that the two numbers are, in fact, different because GROUP BY
> clause separates them into separate groups. So, I want to see the two
> numbers fully expanded for verification purposes.
>
> Thank you!
> Sergey
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 29 2000 - 13:58:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US