BEGIN FOR c IN ( SELECT table_name FROM user_tables WHERE table_name LIKE 'EXT_%' ) LOOP EXECUTE IMMEDIATE 'DROP TABLE ' || c.table_name; END LOOP; END;
No comments:
Post a Comment