Skip to Main Content
Oracle PL/SQL Performance Tuning Tips & Techniques
book

Oracle PL/SQL Performance Tuning Tips & Techniques

by Michael Rosenblum, Paul Dorsey
August 2014
Intermediate to advanced content levelIntermediate to advanced
336 pages
7h 58m
English
McGraw Hill Computing
Content preview from Oracle PL/SQL Performance Tuning Tips & Techniques

Image

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein

Publisher Resources

ISBN: 9780071824828