O'Reilly logo

Oracle PL/SQL For Dummies by Paul Dorsey, Michael Rosenblum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required