这个我一点儿也不知道……自己试着写了一下也不对……
declare
v_count number;
v_id number :=1004;
v_name varchar2(20) :='唐僧';
v_age number := 500;
begin
execute immediate 'insert into tem_user values(:1,:2,:3)' into v_count using v_id,v_name,v_age;
dbms_output.put_line(v_count);
end;
declare
v_count number;
v_id number :=1004;
v_name varchar2(20) :='唐僧';
v_age number := 500;
begin
execute immediate 'insert into tem_user values(:1,:2,:3)' into v_count using v_id,v_name,v_age;
dbms_output.put_line(v_count);
end;
SQL>
SQL> DECLARE
2 v_count NUMBER;
3 v_id NUMBER := 1004;
4 v_name VARCHAR2(20) := '唐僧';
5 v_age NUMBER := 500;
6 BEGIN
7 EXECUTE IMMEDIATE 'insert into tem_user values(:1,:2,:3)'
8 USING v_id, v_name, v_age;
9 --使用sql%rowcount取得影响的行数
10 dbms_output.put_line('影响的行数为:'||sql%rowcount);
11 END;
12 /
影响的行数为:1
PL/SQL procedure successfully completed
SQL>