1. 在PL/SQL运行DDL语句
begin
execute immediate 'set role all'
end
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
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)