質問編集履歴
1
列名を修正
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
|
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
|
|