SQL in PL/SQL

This chapter is from the book

Oracle PL/SQL by Example, 5th Edition

Learn More Buy

This chapter is from the book

This chapter is from the book 

Oracle PL/SQL by Example, 5th Edition

Learn More Buy

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.