DECLARE
CURSOR C1 IS SELECT * FROM USER_TABLES WHERE TABLE_NAME LIKE 'JX%';
V C1%ROWTYPE;
BEGIN
OPEN C1;
LOOP
FETCH C1 INTO V;
EXIT WHEN C1%NOTFOUND;
EXECUTE IMMEDIATE 'DROP TABLE V.TABLE_NAME';
END LOOP;
CLOSE C1;
END;
报错表或视图不存在,用DBMS_OUTPUT.PUT_LINE()能打印出来,但删除不行这是怎么回事啊?