Re: Displaying NUMBER data

From: <gjlinker_at_my-deja.com>
Date: Sat, 02 Sep 2000 22:07:04 GMT
Message-ID: <8ortlv$f5t$1@nnrp1.deja.com>

In order to avoid these data formatting issues in SQL*Plus I wrote a utility called SQL*XL that fetches data into Excel. Excel is extremely flexible and good at presenting data. SQL*XL specialises in getting the data into Excel and present it clearly.

Have a look at SQL*XL at http://www.oraxcel.com

Regards, Gerrit-Jan Linker

In article <8ogqa5$lk6$1_at_nnrp1.deja.com>, sergey_s_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 02 2000 - 17:07:04 CDT