Sqlplus output are a pain for end users (if too many columns), Here is a middle middle ground, without too much work and without a client, giving output with html tags.
Here is quick step on formatting with html, I think we should offer, since little work for us, and gives some formatting.
- Save the below sql as html.sql (taken from http://uhesse.com)
- Run the users sql, it will output on screen
- Run @html
- HTML out put will go in myoutput.html
==
----------------------------------------
-- get the last SQL*Plus output in HTML
-- after Tanel Poder
----------------------------------------
set termout off
set markup HTML ON HEAD " -
-
" -
BODY "" -
TABLE "border='1' align='center' summary='Script output'" -
SPOOL ON ENTMAP ON PREFORMAT OFF
spool myoutput.html
l
/
spool off
set markup html off spool off
host firefox myoutput.html
set termout on
No comments:
Post a Comment