回答編集履歴
2
訂正2回目
answer
CHANGED
|
@@ -25,7 +25,9 @@
|
|
|
25
25
|
BEGIN
|
|
26
26
|
FOR REC_TA IN CUR_TA LOOP
|
|
27
27
|
EXECUTE IMMEDIATE REC_TA.SQL_STRING INTO L_COUNTS ;
|
|
28
|
+
IF L_COUNTS > 0 THEN
|
|
28
|
-
|
|
29
|
+
DBMS_OUTPUT.PUT_LINE(REC_TA.TABLE_NAME || ' ' || TO_CHAR(L_COUNTS)) ;
|
|
30
|
+
END IF ;
|
|
29
31
|
END LOOP ;
|
|
30
32
|
END ;
|
|
31
33
|
/
|
1
訂正
answer
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
IS
|
|
12
12
|
SELECT
|
|
13
13
|
COL.TABLE_NAME
|
|
14
|
-
, 'SELECT COUNT(*) AS COUNTS FROM ' || COL.TABLE_NAME || ' WHERE &&C1 > 999' AS SQL_STRING
|
|
14
|
+
, 'SELECT COUNT(*) AS COUNTS FROM ' || COL.TABLE_NAME || ' WHERE &&C1 >= 999' AS SQL_STRING
|
|
15
15
|
FROM
|
|
16
16
|
USER_TABLES TA
|
|
17
17
|
INNER JOIN
|