Chapter 6
PL/SQL and SQL Working Together
In This Chapter
Finding out how cursors work
Declaring cursors: when and where
Looking at the pros and cons of using implicit cursors
Making use of cursor variables
Structuring cursors for updates and shortcuts
Using PL/SQL functions in SQL
The main reason to use PL/SQL as a programming language is that it works really well with SQL. PL/SQL works better with SQL than any other programming language does. This cooperation works both ways; you can embed SQL in PL/SQL code, and you can call PL/SQL functions within SQL structures. This chapter shows you how to use both languages together more effectively. For example, you find out
How to integrate SQL into PL/SQL with cursors: Cursors are one of the most efficient portions of the PL/SQL language. ...
Get Oracle PL/SQL For Dummies 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.
