Summary
In this chapter, we discussed the importance of cursor structures in the PL/SQL code. We understood the working of cursor structures, their execution cycle, design considerations, and guidelines. We discussed implicit and explicit cursors and covered the working of cursor variables. Meanwhile, we learnt how cursor variables are superior to static cursors. At the end, we overviewed the working of subtypes in Oracle. Subtypes can be a handy feature in large database systems to provide flexibility and maintenance of data types in a modularized way.
In the next chapter, we shall cover composite data types and understand how collections can boost PL/SQL code performance and perform data caching.
