sqlplus HTML format issue
From: JAW <jwilliam_at_aglresources.com>
Date: Wed, 6 Aug 2008 16:11:00 -0700 (PDT)
Message-ID: <b45c5310-7110-4046-badd-478e9a27483a@x41g2000hsb.googlegroups.com>
Date: Wed, 6 Aug 2008 16:11:00 -0700 (PDT)
Message-ID: <b45c5310-7110-4046-badd-478e9a27483a@x41g2000hsb.googlegroups.com>
I use the below to create output that can be read in HTML from MS
EXCEL when I run a sql statement.
It works good except this once
SET LINESIZE 999 VERIFY OFF FEEDBACK OFF PAGESIZE 50000 SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF I have a column called XXX_NUMBER as VARCHAR2(38) (They got a design problme I know). It is in the query.
The output comes back in scientific notation. All other sql is fine.
2.13653E+19
2.33855E+19
It seems like a conversion issue of some sort.
JAW Received on Wed Aug 06 2008 - 18:11:00 CDT