转个sqlplus报告模板

原文链接：http://www.xifenfei.com/oracle_recovery_check

-----定义工具名称
define v_tool_name=wjf_tool
-----定义输出文件名
define fileName=wjf_tool_file
​
​
prompt 
prompt +----------------------------------------------------------------------------+
prompt |                       Oracle &v_tool_name Report                           |
prompt |----------------------------------------------------------------------------+
prompt |                            author:wjf                                      |
prompt +----------------------------------------------------------------------------+
prompt desc:balabala 
​
---定义标题
define v_reportHeader="<font size=+3 color=darkgreen><b>Oracle &v_tool_name Report </b></font>"
​
---格式设置（不需要修改）
set termout       off
set echo          off
set feedback      off
set verify        off
set wrap          on
set trimspool     on
set serveroutput  on
set escape        on
set pagesize 50000
set long     2000000000
set numw 16
col error format a30
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set markup html on spool on preformat off entmap on -
head ' -
  <title>Oracle Database recovery check result</title> -
  <style type="text/css"> -
    body              {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
    p                 {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
    table,tr,td       {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#FFFFCC; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} -
    th                {font:bold 10pt Arial,Helvetica,sans-serif; color:White; background:#0066cc; padding:0px 0px 0px 0px;} -
    h1                {font:bold 12pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:#0066cc; 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:10pt Arial,Helvetica,sans-serif; color:#663300; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
  </style>' -
body   'BGCOLOR="#C0C0C0"' -
table  'WIDTH="90%" BORDER="1"' 
​
--提取文件名
COLUMN spool_time NEW_VALUE _spool_time NOPRINT
SELECT TO_CHAR(SYSDATE,'YYYYMMDD') spool_time FROM dual;
spool &FileName._&_spool_time..html
set markup html on entmap off
prompt &v_reportHeader
​
-----主程序
--version
prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Version Info</b></font><hr align="center" width="250"></center>
select * from v$version;
​
spool off
prompt
exit;

生成的html效果如下：