execute immediate
---example
declare
sqlstr varchar2(200);
begin
sqlstr := 'drop table bao_temp';
execute immediate sqlstr;
sqlstr := 'create table bao_temp (id number(10))';
execute immediate sqlstr;
end;
/SQL> declare
2 sqlstr varchar2(200);
3 begin
4 sqlstr := 'drop table bao_temp';
5 execute immediate sqlstr;
6 sqlstr := 'create table bao_temp (id number(10))';
7 execute immediate sqlstr;
8 end;
9 /PL/SQL 程序順利完成目前歷時: 00:00:00.10
SQL> select * from bao_temp
2 /沒有任何資料列被選取目前歷時: 00:00:00.16
SQL> desc bao_temp
名稱
-----------------------------------------------------------
ID
---example
declare
sqlstr varchar2(200);
begin
sqlstr := 'drop table bao_temp';
execute immediate sqlstr;
sqlstr := 'create table bao_temp (id number(10))';
execute immediate sqlstr;
end;
/SQL> declare
2 sqlstr varchar2(200);
3 begin
4 sqlstr := 'drop table bao_temp';
5 execute immediate sqlstr;
6 sqlstr := 'create table bao_temp (id number(10))';
7 execute immediate sqlstr;
8 end;
9 /PL/SQL 程序順利完成目前歷時: 00:00:00.10
SQL> select * from bao_temp
2 /沒有任何資料列被選取目前歷時: 00:00:00.16
SQL> desc bao_temp
名稱
-----------------------------------------------------------
ID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货