摘要： 绑定变量输出删除的行数在plsql的命令窗口中执行，默认打印出绑定变量的值 SQL> VARIABLE rows_deleted NUMBERSQL> DECLARE 2 v_id NUMBER:= 11; 4 BEGIN 5 DELETE FROM building WHERE id = v_id; 6 :rows_deleted := SQL%ROWCOUNT; 7 END; 8 /PL/SQL procedure successfully completedrows_deleted---------0正常变量无法通过打印方式输出 SQL> VARIABLE rows_d 阅读全文