Re: sqlplus HTML format issue
Date: Thu, 07 Aug 2008 15:42:28 +1000
JAW <jwilliam_at_aglresources.com> writes:
> 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.
I don't think its a conversion issue so much as the default/normal behavior. Wrap the column in a to_char function with the appropriate number format spec and it should work fine.
-- tcross (at) rapttech dot com dot auReceived on Thu Aug 07 2008 - 00:42:28 CDT