Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Getting Rid of Scientific Notation
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 Mon Aug 06 2001 - 18:49:15 CDT