回答編集履歴
2
訂正2回目
test
CHANGED
@@ -52,7 +52,11 @@
|
|
52
52
|
|
53
53
|
EXECUTE IMMEDIATE REC_TA.SQL_STRING INTO L_COUNTS ;
|
54
54
|
|
55
|
+
IF L_COUNTS > 0 THEN
|
56
|
+
|
55
|
-
DBMS_OUTPUT.PUT_LINE(REC_TA.TABLE_NAME || ' ' || TO_CHAR(L_COUNTS)) ;
|
57
|
+
DBMS_OUTPUT.PUT_LINE(REC_TA.TABLE_NAME || ' ' || TO_CHAR(L_COUNTS)) ;
|
58
|
+
|
59
|
+
END IF ;
|
56
60
|
|
57
61
|
END LOOP ;
|
58
62
|
|
1
訂正
test
CHANGED
@@ -24,7 +24,7 @@
|
|
24
24
|
|
25
25
|
COL.TABLE_NAME
|
26
26
|
|
27
|
-
, 'SELECT COUNT(*) AS COUNTS FROM ' || COL.TABLE_NAME || ' WHERE &&C1 > 999' AS SQL_STRING
|
27
|
+
, 'SELECT COUNT(*) AS COUNTS FROM ' || COL.TABLE_NAME || ' WHERE &&C1 >= 999' AS SQL_STRING
|
28
28
|
|
29
29
|
FROM
|
30
30
|
|