4楼一般情况下是可以的,其他的都是查看表结构吧? 要不写个简单的匿名块吧 DECLARE V_C NUMBER; BEGIN FOR X IN (SELECT TABLE_NAME FROM TABS) LOOP BEGIN EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||X.TABLE_NAME INTO V_C; IF V_C=0 THEN DBMS_OUTPUT.PUT_LINE(X.TABLE_NAME); END IF; EXCEPTION WHEN OTHERS THEN NULL; END; END LOOP; END; /
要不写个简单的匿名块吧
DECLARE
V_C NUMBER;
BEGIN
FOR X IN (SELECT TABLE_NAME FROM TABS) LOOP
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||X.TABLE_NAME INTO V_C;
IF V_C=0 THEN DBMS_OUTPUT.PUT_LINE(X.TABLE_NAME); END IF;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
END LOOP;
END;
/