O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

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 3 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 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 ...

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