Summary
In this chapter, you learned how to make use of variables and the various ways to populate variables. Use of DML (Data Manipulation Language) within a PL/SQL block was illustrated in examples with insert statements. These examples also made use of sequences to generate unique numbers.
The last section of the chapter covered transactional control in PL/SQL by explaining what it means to commit data as well as how SAVEPOINTs are used. The final examples demonstrated how committed data could be reversed by using ROLLBACKs in conjunction with SAVEPOINTs.