Drop all tables and sequences in Oracle
Sometimes, when cleaning up my db, I need to drop all the tables and sequences in Oracle. But the SQL Developer for some reason does not have the functionality to select the tables that I want to drop via the User Interfaces.
select 'drop table ' || table_name || ';' from user_tables;
select 'drop sequence ' || sequence_name || ';' from user_sequences;
This will generate the script to drop all the tables and sequences.