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, 1633🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...