sqlplus HTML format issue
Date: Wed, 6 Aug 2008 16:11:00 -0700 (PDT)
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.
It seems like a conversion issue of some sort.
JAW Received on Wed Aug 06 2008 - 18:11:00 CDT