Trying to format a html output in sqlplus. Report out ok, 1 of my columns just doesnt want to change its width and its wrapping. The col width is varchar2 50 and can have varying sentences in it. All words are wrapping. so for example if the data has
"this is a sentence"
the column comes out wrapped ala
"this
is
a
sentence"
I tried setting the col format but no joy, the column after it is a smaller width, has similar varchar data and doesnt wrap. I tried placing my wrapping column placement but still wraps.
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE> Jobs with Critical Page Alerts</TITLE> -
<STYLE type='text/css'> -
<!-- BODY {background: #FFFFC6} --> -
</STYLE>" -
BODY "TEXT='#000000'" -
TABLE "WIDTH='90%' BORDER='5'"
col crit_alert head "Critical Alert" format a70
spool c:\temp\file.html
select crit_alert, crit_name
from crit_Table;
Ive written SQLplus HTML format for years, never seen this before.