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
2018-02-01, 995👍, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...