Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 4. SQL in PL/SQL

Chapter Objectives In this Chapter, you will learn about: ✓ Making Use of DML in PL/SQL ✓ Making Use of SAVEPOINT

This chapter is a collection of some fundamental elements ofusing SQL statements in PL/SQL blocks. In the previous chapter, you initialized variables with the “:=” syntax; in this chapter, we will introduce the method of using a SQL select statement to update the value of a variable. These variables can then be used in DML statements (INSERT, DELETE, or UPDATE). Additionally, we will demonstrate how you can use a sequence in your DML statements within a PL/SQL block much as you would in a stand-alone SQL statement.

A transaction in Oracle is a series of SQL statements that have been grouped together into ...