August 2014
Intermediate to advanced
336 pages
7h 58m
English

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, ...