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, 1630🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...