Re: sqlplus HTML format issue
Date: Thu, 07 Aug 2008 20:59:08 +0200
> 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.
Add this before your set statements:
col[umn] xxx_number for[mat] 999,999,999,999,999,999,990.00
more general: look up formatting options in the SQL*Plus guide
-- Regards, Frank van BortelReceived on Thu Aug 07 2008 - 13:59:08 CDT