Skip to content

{ Tag Archives } database

How to drop all tables in Oracle

Handy little snippet to drop all tables in a database by user.

SELECT 'DROP TABLE ' || table_name || ' CASCADE CONSTRAINTS;' FROM user_tables;

Also tagged
2008 05 19 jcblitz Computing Comments (2)

Do programmer have a fear of commitment? Database commits that is

Every now and then you’ll see my throw up my hands in frustration and mutter something “why aren’t you showing up!” It’s a common scenario, you insert some data directly into the database, command+tab over to your favorite web browser with your application already loaded up, hit refresh…record doesn’t show up. Where is it!!! Well, [...]

Also tagged
2008 05 15 jcblitz Software Comments (0)