全部博文
-
编辑 删除
oracle 之 sql%rowcount 查看受影响的记录行数
sql%rowcount必须在commit或者rollback之前create or replace procedure t_ts(TABLE_NAME VARCHAR2) AS n number; V_SQL VARCHAR2(500);BEGIN V_SQL := Q'[delete from ]' || TABLE_NAME || Q'[]'; EXECUTE IMMEDIATE V_SQL; n := sql%rowcount; COMMIT; dbms_output.put_line(n);end t_ts;create or replace procedure t_ts(TABLE_NAME VARCHAR2) AS n number; V_SQL VARCHAR2(500);BEGIN V_SQL := Q'[delet
