oracle存储过程中怎么用循环delete多张表

Question

如题所述

Answer 1

delete多张表？？
create or replace produce 过程名（变量 out/in 类型）
as
--PLSQL语句
--循环的话用loop
--退出条件用exit when 条件(为ture)退出循环
begin
loop
exit when 条件;
delete from 表名 where 条件;
--delete多张表实在有点看不懂！！你是要删除字段还是删除表
end loop;
end;/
基本格式就这样了！！好的话请采纳！！！！！

Answer 2

for i in (多张表的结果集) loop
execute immediate 'drop table i.table_name';
end loop;

Answer 3

begin
for t in (select owner,table_name from dba_tables where xxxx) loop
execute immediate 'delete from '||t.owner||'.'t.table_Name;
end loop;
end
commit ；本回答被网友采纳

Answer 4

begin
for t in (select owner,table_name from dba_tables where xxxx) loop
execute immediate 'delete from '||t.owner||'.'t.table_Name;
end loop;
end;本回答被网友采纳