Re: sqlplus HTML format issue
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 07 Aug 2008 20:59:08 +0200
Message-ID: <8f868$489b45fc$524b5c40$13491@cache5.tilbu1.nb.home.nl>
Date: Thu, 07 Aug 2008 20:59:08 +0200
Message-ID: <8f868$489b45fc$524b5c40$13491@cache5.tilbu1.nb.home.nl>
JAW wrote:
> 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
>
>
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