It’s important to know when not to use cursor FOR loops.
My mentor told me that when querying data I should always use a cursor FOR loop, even for a single row lookup. It’s great to learn from others, and it’s especially wonderful when the lesson you learn is simple and easy to remember.
Part 12 in a series of articles on understanding and using PL/SQL The central purpose of the Oracle PL/SQL language is to make it as easy and efficient as possible to query and change the contents of tables in a database.
You must, of course, use the SQL language to access tables, and each time you do so, you use a to get the job done.
When we want to update or delete the cursor fetched row(s) from the database, we don’t have to form In the below code listing, the employees joined before the year 2000 are archived and during the cursor process, no other session is permitted to make any changes to those employees using the FOR UPDATE clause.