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