CHAPTER5Thinking in Sets
The first PL/SQL code elements to consider when deciding how to properly use SQL inside of PL/SQL are cursors. The battle between proponents of implicit cursors and proponents of explicit cursors is as old as Oracle databases. Sadly, online fighters often ignore the key feature of database cursors. They are nothing more than pointers to SQL sets, and unless you start thinking in sets, you will be missing the forest for the trees.
Working in sets is often a new experience for rank-and-file server-side developers. To be fair, there are some good reasons to explain their lack of understanding:
In legacy environments, ...
Get Oracle PL/SQL Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
