Oracle updating cursor b c canada dating single
Let's take an example to demonstrate the use of explicit cursor.
In this example, we are using the already created CUSTOMERS table.
A cursor is a temporary work area created in the system memory when a SQL statement is executed.
This temporary work area is used to store the data retrieved from the database, and manipulate this data.
These are created by default to process the statements when DML statements like INSERT, UPDATE, DELETE etc. Orcale provides some attributes known as Implicit cursor's attributes to check the status of DML operations.
Oracle provides few attributes called as implicit cursor attributes to check the status of DML operations.
The cursor attributes available are %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.
Have you tuned that SQL statement so that it effeciently pulls the data out of the database? Take the COMMIT out of the loop and see if that helps your performance.
You also mentioned that you are updating rows in another table in your cursor's loop. Finally, are you sure that you cannot perform this as one simple SQL statement rather than updating in a cursor's loop?
Search for oracle updating cursor:
Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row.