Oracle中execute？

執行動態的SQL語句或非運行時創建的PL/SQL塊.動態創建和執行SQL語句

EXECUTE IMMEDIATE -- 用法例子

1. 在PL/SQL運行DDL語句

begin

execute immediate 'set role all';

end;

2. 給動態語句傳值(USING 子句)

declare

l_depnam varchar2(20) := 'testing';

l_loc varchar2(10) := 'Dubai';

begin

execute immediate 'insert into dept values (:1, :2, :3)'

using 50, l_depnam, l_loc;

commit;

end;

3. 從動態語句檢索值(INTO子句)

declare

l_cnt varchar2(20);

begin

execute immediate 'select count(1) from emp'

into l_cnt;

dbms_output.put_line(l_cnt);

end;