
set term off
/*
*
*  Author     : Vishal Gupta
*  Purpose    : Display results in HTML
*  Parameters : 
*               
*               
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  08-Mar-12  Vishal Gupta  Intial version
*
*
*/

PROMPT
PROMPT    Running -  @&&1 "&&2" "&&3" "&&4" "&&5" "&&6" "&&7" "&&8" "&&9" "&&10"
PROMPT

DEFINE command="&&1"
DEFINE arg1="&&2"
DEFINE arg2="&&3"
DEFINE arg3="&&4"
DEFINE arg4="&&5"
DEFINE arg5="&&6"
DEFINE arg6="&&7"
DEFINE arg7="&&8"
DEFINE arg8="&&9"
DEFINE arg9="&&10"

UNDEFINE 1
UNDEFINE 2
UNDEFINE 3
UNDEFINE 4
UNDEFINE 5
UNDEFINE 6
UNDEFINE 7
UNDEFINE 8
UNDEFINE 9
UNDEFINE 10

set MARKUP HTML ON PREFORMAT OFF  spool on ENTMAP ON -
HEAD "<TITLE>HTML Output</title> -
<style type='text/css'> -
body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
p {font:8pt 'Courier New',Courier,monospace; color:black; background:White;} -
table,tr {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#FFFFFF; padding:0px 1px 0px 3px; margin:0px 0px 0px 0px;white-space:nowrap;} -
tr:nth-child(odd) {background: #EAEFF1} - 
tr:nth-child(even)  {background: #FFFFFF} -
th {font:bold 10pt Arial,Helvetica,sans-serif; color:white; background:#336699; padding:0px 2px 0px 2px;} -
td {font:10pt Arial,Helvetica,sans-serif; padding:0px 1px 0px 3px; margin:0px 0px 0px 0px;} -
h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} -
h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} -
a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
</style> -
"  -
BODY "TEXT='#000000' "  -
TABLE " BORDER='2' RULES='all' " 
spool sqlplus_html_report.html
@&&command "&&arg1" "&&arg2" "&&arg3" "&&arg4" "&&arg5" "&&arg6" "&&arg7" "&&arg8" "&&arg9" 

spool off
set MARKUP HTML OFF

set term on

PROMPT
PROMPT  HTML output created in sqlplus_html_report.html file.
PROMPT  Opening the file in your default internet browser (IE, Chrome, Firefox etc) ...
PROMPT

host sqlplus_html_report.html
--host rm sqlplus_html_report.htm

