Oracle 10.2.0.3
IBM AIX5.3
Trying to generate report based on some simple SQLs. Everything works except for formatting in html.
"column cola format a25" working in plain output, but html not working as it goes in free flow format. Even tried to control the column heading, but didn't help much...
Basically I want cola and colx to have same column width in html output
irrespective of data.
Thoughts?
set numwidth 30
set verify off
set pagesize 1000 linesize 150 termout off
set markup html on spool on ENTMAP OFF HEAD '' -
body 'TEXT=blue'
set numwidth 30
column cola format a25 wrap
column colb format a30 wrap
column colc format a35 wrap
column colx format a25 wrap
column coly format a30 wrap
column colz format a35 wrap
spool /data/rpt_test.htm
select cola , colb, colc from tablea;
select colx , coly, colz from tableb;
spool off
set markup html off