BEGIN
FOR t IN (SELECT table_name FROM user_tables WHERE table_name LIKE 'your_prefix%') LOOP
EXECUTE IMMEDIATE 'DROP TABLE "' || t.table_name || '" CASCADE CONSTRAINTS';
END LOOP;
END;
根据需要,修改WHERE table_name LIKE 'your_prefix%' 的内容
BEGIN
FOR t IN (SELECT table_name FROM user_tables WHERE table_name LIKE 'your_prefix%') LOOP
EXECUTE IMMEDIATE 'DROP TABLE "' || t.table_name || '" CASCADE CONSTRAINTS';
END LOOP;
END;
根据需要,修改WHERE table_name LIKE 'your_prefix%' 的内容