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:
Transaction processing
Retrieving data with basic select statements, Oracle Text information retrieval, ...
Get Oracle Database 10g PL/SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
