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:
Retrieving data with basic select statements, Oracle Text information retrieval, ...