Updating row using cursor oracle
BEGIN FOR item IN ( SELECT object_name, status FROM user_objects WHERE object_type = 'INDEX' AND object_name NOT LIKE '%$%' ) LOOP dbms_output.put_line('Index = '
The cursor is closed even if you use an IIf you need to reference the same query from different parts of the same procedure, you can declare a cursor that specifies the query, and process the results using a FOR loop.PL/SQL also supports dynamic SQL, which enables you to execute SQL data definition, data control, and session control statements dynamically.In addition, PL/SQL conforms to the current ANSI/ISO SQL standard.The following sections describe all the query-processing features that explicit cursors provide.
In traditional database programming, you process query results using an internal data structure called a cursor.
At the end of a transaction that makes database changes, Oracle makes all the changes permanent or undoes them all.