DBOutputService/test/nuke_tables.sql

0001 BEGIN
0002   FOR result IN (SELECT table_name FROM user_tables)
0003   LOOP
0004     EXECUTE IMMEDIATE 'DROP TABLE ' || result.table_name || ' CASCADE
0005 CONSTRAINTS';
0006   END LOOP;
0007 END;
0008 /
0009