Collections:
Attributes of the Implicit Cursor in Oracle
How To Use Attributes of the Implicit Cursor in Oracle?
✍: FYIcenter.com
Right after executing a DML statement, you retrieve any attribute of the implicit cursor by using SQL%attribute_name, as shown in the following tutorial exercise:
CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL); Table created. DECLARE id NUMBER; first_name CHAR(10); BEGIN id := 29; first_name := 'Bob'; INSERT INTO student VALUES(id, first_name, 'Henry'); first_name := 'Joe'; INSERT INTO student VALUES(id+1, first_name, 'Bush'); DBMS_OUTPUT.PUT_LINE('# of rows inserted: ' || SQL%ROWCOUNT); first_name := 'Fyi'; UPDATE student SET first_name = first_name WHERE id = 29; IF SQL%FOUND THEN DBMS_OUTPUT.PUT_LINE('# of rows updated: ' || SQL%ROWCOUNT); END IF; UPDATE student SET first_name = first_name WHERE id = id+1; IF SQL%NOTFOUND THEN DBMS_OUTPUT.PUT_LINE('No records updated.'); END IF; DELETE FROM student WHERE id = id; DBMS_OUTPUT.PUT_LINE('# of rows deleted: ' || SQL%ROWCOUNT); END; / # of rows inserted: 1 # of rows updated: 1 No records updated. # of rows deleted: 2
⇒ Loop through the Implicit Cursor in Oracle
⇐ What Is the Implicit Cursor in Oracle
2018-02-01, 1651🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...