O'Reilly logo

Oracle Database 10g PL/SQL Programming by Michael McLaughlin, Ron Hardman, Scott Urman

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 4Using SQL with PL/SQL

PL/SQL is Oracle's procedural language extension to the Structured Query Language (SQL). SQL is used to select data from the database, manipulate that data, and return the results to the end user and/or write it to the data source. As was mentioned in Chapter 1, SQL is the window to the database, and PL/SQL helps us exploit what it can do.

This chapter focuses on how SQL can be used in PL/SQL and presents some advanced features that improve application performance and design. In this chapter, we discuss the following:

Image Transaction processing

Retrieving data with basic select statements, Oracle Text information retrieval, ...

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