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 of using SQL statements in PL/SQL blocks. In the preceding chapter, you initialized variables with the
:= syntax. This chapter introduces the method of using a SQL select statement to update the value of a variable. These variables can then be used in data manipulation (DML) statements (Insert, Delete, or Update). Additionally, this chapter demonstrates 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 the programmer has ...