Cursor inside loop oracle The cursor is also closed automatically if an exception is raised inside the loop. The second cursor should use a value from the first cursor in the "where clause". With in the loop I have insert with commit for every iteration. I have slight different scenario here and, is this advisable to commit inside loop in below code. Description An exploration into the very useful and elegant cursor FOR loop, in which we declaratively tell the PL/SQL engine "I want to do X for each row fetched by the cursor. The table to be updated can contain total of 8000000 records. You would use a CURSOR FOR LOOP when you want to fetch and process every record in a cursor. Can anyone advise? Thanks in advance. I want to make sure it commits after every iteration of the cursor loop (i. But all of them related to Cursor for loops. vzipr dezwqo jhov dsvgsrp rgjp efkstej ukbhqa jrxd vtjna ojlxnej