select 'drop table '||table_name||' purge;' from user_tables where table_name like 'AAA%' 注意 table_name like 'AAA%' 表名必须是大写