17,086
社区成员
发帖
与我相关
我的任务
分享
1 declare
2 v_count int;
3 begin
4 execute immediate 'delete from t where rownum < 10';
5 v_count := sql%rowcount;
6 dbms_output.put_line('deleted '||v_count||' rows ');
7 execute immediate 'update t set created = sysdate where rownum < 10';
8 v_count := sql%rowcount;
9 dbms_output.put_line('updated '||v_count||' rows ');
10* end;
14:03:16 SQL> /
deleted 9 rows
updated 9 rows
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
14:03:16 SQL>