Oracle中“execute immediate”是什么意思？執(zhí)行動態(tài)的SQL語句或非運行時創(chuàng)建的PL/SQL塊.動態(tài)創(chuàng)建和執(zhí)行SQL語句EXECUTE IMMEDIATE -- 用法例子1. 在P

Oracle中“execute immediate”是什么意思？

執(zhí)行動態(tài)的SQL語句或非運行時創(chuàng)建的PL/SQL塊.動態(tài)創(chuàng)建和執(zhí)行SQL語句

EXECUTE IMMEDIATE -- 用法例子

1. 在PL/SQL運行DDL語句

begin

execute immediate "set role all"

end

2. 給動態(tài)語句傳值(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. 從動態(tài)語句檢索值(INTO子句)

declare

l_cnt varchar2(20)

begin

execute immediate "select count(1) from emp"

into l_cnt

dbms_output.put_line(l_cnt)

end