Contents Introduction xvii CHAPTER 1 PL/SQL Concepts 1 LAB 1.1 PL/SQL in Client/Server Architecture 2 LAB 1.2 PL/SQL in SQL*Plus 12 CHAPTER 2 General Programming Language Fundamentals 21 LAB 2.1 PL/SQL Programming Fundamentals 22 Chapter 2 Try It Yourself 37 CHAPTER 3 SQL in PL/SQL 39 LAB 3.1 Making Use of DML in PL/SQL 40 LAB 3.2 Making Use of SAVEPOINT 45 Chapter 3 Try It Yourself 51 CHAPTER 4 Conditional Control: IF Statements 53 LAB 4.1 IF Statements 54 LAB 4.2 ELSIF Statements 65 LAB 4.3 Nested IF Statements 74 Chapter 4 Try It Yourself 80 CHAPTER 5 Conditional Control: CASE Statements 81 LAB 5.1 CASE Statements 82 LAB 5.2 CASE Expressions 96 LAB 5.3 NULLIF and COALESCE Functions 103 Chapter 5 Try It Yourself 112 CHAPTER 6 Iterative Control: Part I 113 LAB 6.1 Simple Loops 114 LAB 6.2 WHILE Loops 124 LAB 6.3 Numeric FOR Loops 132 Chapter 6 Try It Yourself 142 CHAPTER 7 Iterative Control: Part II 143 CHAPTER 8 Error Handling and Built-in Exceptions 16……