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>

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

Original text of this message