質問編集履歴

1

列名を修正

2018/10/05 15:47

投稿

kamiyui_bidan
kamiyui_bidan

スコア47

test CHANGED
File without changes
test CHANGED
@@ -14,7 +14,7 @@
14
14
 
15
15
  IF %%a == "MST" (
16
16
 
17
- EXP user1/pw@db1 FILE=file.DMP LOG=EXP.log tables=(%%b^) QUERY=\"WHERE KEIVOL_ym>=TO_CHAR(ADD_MONTHS(SYSDATE, -6), 'YYYYMM') \" STATISTICS=none
17
+ EXP user1/pw@db1 FILE=file.DMP LOG=EXP.log tables=(%%b^) QUERY=\"WHERE Col1>=TO_CHAR(ADD_MONTHS(SYSDATE, -6), 'YYYYMM') \" STATISTICS=none
18
18
 
19
19
  ) ELSE (
20
20