Hi,
I have written a pl/sql code to retrive some data from database and spool this in .lst file.But I need .html file so I changed the code and use command "set markup html on".But when the .html file is created its format is changed compare to .lst file which is previously created i.e space between the two character and <br> tag shows after every line.
The code is like that:
Set serveroutput on
set pages 400
set line 500
set markup html on
spool test.html
Declare
<A cursor is defined here>
Begin
A loop which retrive data from cursor and format the data using lpad, rpad.
end
/
spool off
Please suggest how to generate .html file without changing its format.