Oracle PL/SQL by Example, 6th Edition

3

SQL in PL/SQL

In this chapter, you will learn about

• SQL Statements in PL/SQL

• Transaction Control in PL/SQL

This chapter is a collection of some fundamental aspects of using SQL statements in PL/SQL. In the previous chapter, you learned how to initialize variables with the assignment operator (:=); in this chapter, you will learn how to assign a value to a variable via a SELECT statement. You will also learn how DML statements may be used in the PL/SQL code. Finally, you will learn how to control transactions in PL/SQL.

Lab 3.1: SQL Statements in PL/SQL

After this lab, you will be able to

• Initialize Variables with the SELECT INTO Statement

• Use DML Statements in a PL/SQL Block

• Use a Sequence in a PL/SQL Block

Initializing Variables ...