Sqlplus HTML reports
Tuesday, February 11, 2014
I used following code
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
| set markup HTML ON HEAD "<style type='text/css'> -body { -font:10pt Arial,Helvetica,sans-serif; -color:blue; background:white; } -p { -font:8pt Arial,sans-serif; -color:grey; background:white; } -table,tr,td { -font:10pt Arial,Helvetica,sans-serif; -text-align:right; -color:Black; background:white; -padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; } -th { -font:bold 10pt Arial,Helvetica,sans-serif; -color:#336699; -background:#cccc99; -padding: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;} -.threshold-critical { -font:bold 10pt Arial,Helvetica,sans-serif; -color:red; } -.threshold-warning { -font:bold 10pt Arial,Helvetica,sans-serif; -color:orange; } -.threshold-ok { -font:bold 10pt Arial,Helvetica,sans-serif; -color:green; } -</style> -<title>SQL*Plus Report</title>" -BODY "" - TABLE "border='1' width='90%' align='center'" -ENTMAP OFF SPOOL ON |
Labels: Sqlplus HTML reports
0 comments:
Subscribe to:
Post Comments (Atom)
Powered by Blogger.