--创建测试表
create table t01(id integer,name varchar2(10));
--创建测试数据
insert into t01(id,name) values (1,'a');
insert into t01(id,name) values (2,'b');
insert into t01(id,name) values (3,'c');
--提交
commit;
--查询表的数据
select * from t01;
--使用动态语句为变量赋值
declare id t01.id%type := '1';
name t01.name%type;
begin
execute immediate 'select name from t01 t where id=:1' into name using id;
dbms_output.put_line(name);
end;
--使用动态语句插入数据
declare id t01.id%type := 4;name t01.name%type := 'd';
begin
execute immediate 'insert into t01(id,name) values(:1,:2)' using id,name;
commit;
end;
--使用动态语句更新数据
declare id t01.id%type := 3;name t01.name%type := 'd';
begin
execute immediate 'update t01 set name=:1 where id=:2' using name,id;
commit;
end;
--使用动态语句删除数据
declare id t01.id%type := 4;
begin
execute immediate 'delete from t01 where id=:1' using id;
commit;
end;
using(动态语句)
最新推荐文章于 2020-02-26 22:59:27 发布