菜鸟求助：@@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