Code and think

Oracle cursors

Here are two useful articles on how to use cursors in Oracle scripts.

https://asktom.oracle.com/Misc/oramag/on-cursor-for-loops.html

https://blogs.oracle.com/connect/post/working-with-cursors