SQL output in HTML format

[topstar]

I have got a table with 3 rows and a few hundred columns.

Can I get the formatting required in the SQL statement to generate the output of this table in html format such that when viewed in a HTML viewer, we see the 3 columns and all the rows inside a table, complete with borders? Is it possible to do this? If so can someone tell me how?

Cheers

[sreddy]

Try iSQL*Plus if you are using latest version of Oracle.

[topstar]

I am using Oracle 8.1. I dont think that is available in 8.1 ?

[jovery]

Take a look PL/SQL web toolkit and PSP's

http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76939/adgweb.htm#1002783

Regards

[Tarry]

Try Query Reporter, It's Free and a good tool.

http://www.allroundautomations.nl/queryreporter.html

[pando]

lsc@DEV817-ES7J2BKT8ZM0YY>set markup

Usage: SET MARKUP HTML [ON|OFF] [HEAD text] [BODY text]
[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]