drop all tables and sequences in oracle
18/05/2009tables:
SELECT 'DROP TABLE ' || TABLE_NAME || ' CASCADE CONSTRAINTS;' FROM user_tables;
sequences:
SELECT 'DROP SEQUENCE ' || sequence_name || ';' FROM user_sequences;
tables:
SELECT 'DROP TABLE ' || TABLE_NAME || ' CASCADE CONSTRAINTS;' FROM user_tables;
sequences:
SELECT 'DROP SEQUENCE ' || sequence_name || ';' FROM user_sequences;