Beware though. An underscore (_) represents a single wildcard character.
The SELECT below will find all tables starting with A. You will need to
ESCAPE the underscore.
--Mike
Daniel wrote in message ...
>No, but you can build a quick script with standard sql statements...
>
>select 'drop table '||table_name||';'
> from user_tables
> where table_name like 'A_%';
>
>Daniel
>Austin, TX
>
>"Dana Jian" <djian_at_trasa.com> wrote in message
>news:38874c95$0$74587_at_news.choice.net...
>> Hi,
>>
>> Is there any way to Drop tables which starts with like A_... in PL/SQL or
>in
>> any tools of Oracle?
>>
>> Thanks,
>> Dana
>> djian_at_trasa.com
>>
>>
>
>
Received on Thu Jan 20 2000 - 13:20:32 CST
