2010-03-27

Drop multiple tables in oracle

If you need drop too many tables to do it manually, you can use query like this:

select 'drop table '||table_name||';' from all_tables where table_name like 'T_%';</blockquote>

It will create SQL queries. You can edit them and them run to delete all you want.

Oracle