sqlplus HTML format issue

Giganews Newsgroups
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.

2.13653E+19
2.33855E+19

It seems like a conversion issue of some sort.

JAW

Replies