77 lines
2.4 KiB
SQL
77 lines
2.4 KiB
SQL
|
|
set term off
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display results in HTML
|
|
* Parameters :
|
|
*
|
|
*
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 04-Jun-15 Vishal Gupta Change paragraphs font to Courier New
|
|
* 08-Mar-12 Vishal Gupta Intial version
|
|
*
|
|
*
|
|
*/
|
|
set term on
|
|
|
|
|
|
|
|
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:#f7f7e7; padding:0px 1px 0px 3px; margin:0px 0px 0px 0px;} -
|
|
th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 2px 0px 2px;} -
|
|
td {font:10pt Arial,Helvetica,sans-serif; background:#f7f7e7; 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
|
|
|
|
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
|
|
|