Re: Drop tables in Oracle

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 - 12:02:31 CST