OracleÐÂÊÖÎÊÌâ

create procedure proc_temp
as
begin
    execute immediate 'DDL';
    execute immediate 'DDL';
    execute immediate 'DDL';
end;
    ¶àÌõDDLÓï¾äÀÛ¼Ó¿ÉÒÔ²»£¨ÎÒ»ú×ÓÉÏûOracle)

---

¿ÉÒÔ°¡

---

¿ÉÒÔ£¡

---

up

---

¿ÉÒÔ£¡

---

Õâ¸öÍêȫûÓÐÎÊÌâ

---

SQL> create procedure pro
  2  as
  3  begin
  4  execute immediate 'delete from test';
  5  execute immediate 'drop table test';
  6  end;
  7  /

Procedure created