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: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Tue, 29 Aug 2000 20:04:01 +0200
Message-ID: <8ogtkl$u8m$12$1@news.t-online.com>

Hello Sergey!

Under SQL*Plus: set numwidth 15 (or greater, see related docu).

Stefan.

<sergey_s_at_my-deja.com> schrieb in im Newsbeitrag: 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:04:01 CDT

Original text of this message

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