using(动态语句)
--创建测试表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;
