Chapter 6

PL/SQL and SQL Working Together

In This Chapter

bullet Finding out how cursors work

bullet Declaring cursors: when and where

bullet Looking at the pros and cons of using implicit cursors

bullet Making use of cursor variables

bullet Structuring cursors for updates and shortcuts

bullet 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

bullet 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 live online training, plus books, videos, and digital content from nearly 200 publishers.