Re: Getting Rid of Scientific Notation

the reason for this are the number settings in your NLS_SETTINGS either you change them, or you make a to_char with the correct formatting in the select.

It's Just Me wrote:

> Hi all, I'm hitting a table and I'm giving it a tight WHERE and AND
> with the SELECT's and SUMming on a column (several actually) that
> contain very large numbers for results.
>
> It's so large that out of about 15 columns I'm summing, 3 of the
> summed results are in Scientific Notation. I don't want to divide the
> amounts, as the comparitive system, Teradata, does not have this
> problem and I'm trying to keep the SQL as equal between the two
> systems as possible for the obvious comparistive reasons. Also, if I
> start using math to cut it down, it's a gian pain to use decode in
> Oracle and CASE in Teradata for all the otehr tables with lots of
> columns I've got to do all this work on. Yes, I'm looking for the
> easy way out.
>
> I have tried setting the serveroutputmode to on and I have tried
> setting the linesize to something like 2500 and setting the pagesize
> to 50000 and also used the PL COLUMN command like this...
>
> column incom_charge_amt format 999999999999999
>
> Thats 15 number 9's, I only need 13, but for the next cycle it could
> be bigger.....
>
> This is all I can think of to do and I still get Scientific Notation!!
>
> What do I have to do to get Oracle SQL results to not display the
> results values in Scientific Notation and truely represent the summed
> large values with out dividing the summed number like...
>
> sum(income_charge_amt/600),
>
> All help on this matter is greatly appreciated.
>
> TIA,
>
> mailto:jpquinn_at_home.com
Received on Tue Aug 07 2001 - 01:06:42 CDT