Saturday, October 3, 2009

Delete all rows in Oracle database

1. Run this:
select 'delete from ', table_name, '; ' from user_tables;

2. run and script the output into a file.

3. copy paste the commands from the file into your SQL editor.

done

No comments:

Post a Comment