oracle批量清空表，批量删除表

select ' drop table ' || tname || ';' from tab;清空就把drop 改为truncate

select ' drop table ' || tname || ';' from tab;