データパッチを当てるときのSQLのテンプレート

patchSqlTemplate.sql

SET ECHO ON
SET TIMING ON
SET PAGESIZE 2000
SET LINE 9999
SPOOL PATCHNAME_01_YYYYMMDD.LOG
/*---------------------------------------------------
||  処理開始時刻
---------------------------------------------------*/
SELECT TO_CHAR (SYSDATE,'YYYY/MM/DD HH24:MI:SS') AS 開始時刻 FROM DUAL;

/*---------------------------------------------------
||  接続先
---------------------------------------------------*/
SHOW USER;
SELECT USER,INSTANCE_NAME,HOST_NAME FROM V$INSTANCE;

PAUSE;
/*---------------------------------------------------
||  処理前確認
---------------------------------------------------*/

--PAUSE;
/*---------------------------------------------------
||  メイン処理
---------------------------------------------------*/

--PAUSE;
/*---------------------------------------------------
||  処理後確認
---------------------------------------------------*/

--PAUSE;
/*---------------------------------------------------
||  処理終了時刻
---------------------------------------------------*/
SELECT TO_CHAR (SYSDATE,'YYYY/MM/DD HH24:MI:SS') AS 終了時刻 FROM DUAL
;

SPOOL OFF;


/*---------------------------------------------------
||  OKならCOMMITを行ってください
---------------------------------------------------*/
PAUSE;