|Subject:||sqlplus HTML format issue|
|Posted by:||JAW (jwilli…@aglresources.com)|
|Date:||Wed, 6 Aug 2008|
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.