(
::
=========================================================
::
Adhoc_run.bat
::
=========================================================
:: Jerome Christopher
[Jerome_christopher@yahoo.com]
::
http://sqlhtm.blogspot.com
::
http://www.sqlhtm.com/sqlhtm
::
=========================================================
echo
set pages 1000 lines 200 echo off feedback
off
echo prompt
^<html^>^<head^>
echo set heading off feedback
off
echo
select '^<'^|^|'style
type='^|^|''''^|^|'text'^|^|'^/'^|^|'css'^|^|''''^|^|'^>'^|^|
chr^(10^)^|^|
echo
'body {font:7pt bold Arial,Helvetica,sans-serif;
color:black;
background:^}'^|^|chr^(10^)^|^|
echo
'p {font:bold 8pt
Arial,Helvetica,sans-serif; color:black;
background:}'^|^|chr^(10^)^|^|
echo
'table {font:8pt Arial,Helvetica,sans-serif;
color:Black; background:#f7f7e7;
vertical-align:top;}'^|^|chr^(10^)^|^|
echo
'tr {font:bold 10pt
Arial,Helvetica,sans-serif; color:red;
background:#f7f7e7;}'^|^|chr^(10^)^|^|
echo
'td {font:bold 7pt
Arial,Helvetica,sans-serif; color:black;
background:aqua;}'^|^|chr^(10^)^|^|
echo
'th {font:bold 6pt
Arial,Helvetica,sans-serif; color:white;
background:olive; }'^|^|chr^(10^)^|^|
echo
'a {font:8pt bold
Arial,Helvetica,sans-serif; color:darkblue; background:;
vertical-align:top;}'^|^|chr^(10^)^|^|
echo
'h1 {font:bold 14pt
verdana,Helvetica,sans-serif; color:Black; background:;
}'^|^|chr^(10^)^|^|
echo
'^<'^|^|'^/'^|^|'style^>' from dual;
echo
prompt ^<^/head^>^<body^>
echo
SET MARKUP HTML ON TABLE ^"^" ENTMAP OFF
echo
select name,to_char^(sysdate,'dd-mon-yy hh:mi:ss pm
Dy'^) Today from v$database;
echo
SET HEADING ON
)>c:\adhoc_run.sql
type
c:\adhoc_paste.tmp >>c:\adhoc_run.sql
echo
exit >>c:\adhoc_run.sql
echo
prompt ^<^/body^>^<^/html^>
>>c:\adhoc_run.sql
sqlplus -s dba-user/pwd@db
@c:\adhoc_run.sql >c:\adhoc_run.hta
start
c:\adhoc_run.hta
exit
