²ËÄñÇóÖú£º@@rowcountÔÚOracleÖÐÈçºÎʵÏÖ

SqlServerÖÐʹÓõÄ@@rowcountÔÚOracleÖÐÈçºÎʵÏÖ£¿

---

SQL code:

sql%rowcount

---

ÎÒ²»Ì«¶®Oracle£¬ÏëÇëÎÊÒ»ÏÂÄãдµÄÉÏÃæÕâ¸ö¾ä×ÓÔõôʹÓÃ,лл!

---

SQL%ROWCOUNT ÊÜÓ°ÏìµÄ¼Ç¼ÊýÊǶàÉÙ¡£

Example 6-4 SQL%ROWCOUNT Attribute

SQL code:
DROP TABLE employees_temp;
CREATE TABLE employees_temp AS
SELECT * from employees;

DECLARE
mgr_no NUMBER(6) := 122;
BEGIN
DELETE from employees_temp WHERE manager_id = mgr_no;
DBMS_OUTPUT.PUT_LINE
('Number of employees deleted: ' || TO_CHAR(SQL%ROWCOUNT));
END;
/
Result:

Number of employees deleted: 8

---

SQL%ROWCOUNT