Created
April 29, 2011 08:22
-
-
Save 544/948041 to your computer and use it in GitHub Desktop.
データパッチを当てるときのSQLのテンプレート
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment