SQL
>
set
serveroutput
on
;
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
>
转载于:https://www.cnblogs.com/gisdream/archive/2012/05/25/2518250.html