create procedure proc_temp
as
begin
execute immediate 'DDL';
execute immediate 'DDL';
execute immediate 'DDL';
end;
多条DDL语句累加可以不(我机子上没Oracle)
as
begin
execute immediate 'DDL';
execute immediate 'DDL';
execute immediate 'DDL';
end;
多条DDL语句累加可以不(我机子上没Oracle)
2 as
3 begin
4 execute immediate 'delete from test';
5 execute immediate 'drop table test';
6 end;
7 /Procedure created