oracle execute用法 Oracle中“execute immediate”是什么意思？
Oracle中“execute immediate”是什么意思？執(zhí)行動(dòng)態(tài)的SQL語句或非運(yùn)行時(shí)創(chuàng)建的PL/SQL塊.動(dòng)態(tài)創(chuàng)建和執(zhí)行SQL語句EXECUTE IMMEDIATE -- 用法例子1. 在P
Oracle中“execute immediate”是什么意思？
執(zhí)行動(dòng)態(tài)的SQL語句或非運(yùn)行時(shí)創(chuàng)建的PL/SQL塊.動(dòng)態(tài)創(chuàng)建和執(zhí)行SQL語句
EXECUTE IMMEDIATE -- 用法例子
1. 在PL/SQL運(yùn)行DDL語句
begin
execute immediate "set role all"
end
2. 給動(dòng)態(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. 從動(dòng)態(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