Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop multiple tables

user12093849Jul 19 2010 — edited Jul 19 2010
Hi

Can you pls help me on this

I have 300 tables starting 'ABC_' and I would like to drop all these table starting with this
drop table select table_name from all_tables where table_name like '%ABC_%'
but the above query is not working,pls help me on this

Thanks a lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2010
Added on Jul 19 2010
5 comments
21,395 views