Devon 1 min read

An Easy Way to Drop All Tables in Your Tablespace in Oracle

Drop all Oracle tables easily - generate a SQL script from querying user_tables, then execute it.

If you need to drop all tables in the database with Oracle, here's an easy way!

run this command:

select 'drop table ', table_name, 'cascade constraints;' from user_tables;

Then copy the output and run that as a sql script.

Continue reading

Forget the perfect prompt - mastering context management is the real secret to productive AI-assisted development.

Keep your personal and work GitHub identities separate with SSH config tricks that route keys automatically.

10MinuteMail is faster and mobile-friendly now - a complete overhaul to match modern web standards.