Implicit CURSORs – Resilient Software and PL/SQL

Implicit CURSORs When Oracle executes a SQL statement using SELECT, UPDATE, etc., it automatically creates an implicit CURSOR. This CURSOR is managed internally and Oracle reveals only a limited amount of information about it. For example, you can get the numbers of rows affected by the query using the following command: SQL%ROWCOUNT If you want […]