Re: sqlplus HTML format issue

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.
>
> 2.13653E+19
> 2.33855E+19
>
>
> 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.

Tim

-- 
tcross (at) rapttech dot com dot au