Printable View
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
Try iSQL*Plus if you are using latest version of Oracle.
I am using Oracle 8.1. I dont think that is available in 8.1 ?
Take a look PL/SQL web toolkit and PSP's
http://download-west.oracle.com/docs...eb.htm#1002783
Regards
Try Query Reporter, It's Free and a good tool.
http://www.allroundautomations.nl/queryreporter.html
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}]