Drop multiple tables in oracle27 March 2010, 18:03:10 |
If you need drop too many tables to do it manually, you can use query like this:
It will create SQL queries. You can edit them and them run to delete all you want.
select ‘drop table ‘||table_name||’;’ from all_tables where table_name like ‘T_%’;
It will create SQL queries. You can edit them and them run to delete all you want.
| Tags: Oracle | Comments [ 0 ] |

Subscribe? Sure? What for?

Leave a Reply