有两种方式
方式一:
BEGIN
FOR TABLENAME IN ( SELECT TABLE_NAME FROM USER_TABLES) LOOP
EXECUTE IMMEDIATE 'DROP TABLE ' || TABLENAME.TABLE_NAME || ' PURGE';
END LOOP;
END;
方式二:
FOR TABLENAME IN ( SELECT TABLE_NAME FROM USER_TABLES) LOOP
EXECUTE IMMEDIATE 'DROP TABLE ' || TABLENAME.TABLE_NAME || ' PURGE';
END LOOP;
END;
方式二:
DECLARE
CURSOR TIANMING_DROP IS
SELECT TABLE_NAME FROM USER_TABLES;
HANG VARCHAR2( 50);
BEGIN
OPEN TIANMING_DROP;
LOOP
FETCH TIANMING_DROP
INTO HANG;
EXIT WHEN TIANMING_DROP%NOTFOUND;
EXECUTE IMMEDIATE 'DROP TABLE ' || HANG;
END LOOP;
CLOSE TIANMING_DROP;
END;