Tuesday 2 October 2012

SQLPlus formating -without any fancy clients

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.
  1. Save the below sql as html.sql (taken from http://uhesse.com)
  2. Run the users sql, it will output on screen
  3. Run @html
  4. 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: