Archive of published articles on May, 2009
Back homedrop 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;