begin

for c in(select table_name from user_tables  where table_name like '%DelTableName%')

loop

EXECUTE IMMEDIATE 'truncate table kdgisdb.'||c.table_name;

end loop; 

end;

这样就能将符合条件的所有表清空