Part II of this book describes the essential language constructs provided by PL/SQL. It includes extensive examples of these constructs and explains how to use them most effectively.

• Chapter 4, Variables and Program Data , explains variables and constants in PL/SQL programs and presents the various PL/SQL datatypes.

• Chapter 5, Conditional and Sequential Control , describes how to use various types of IF, THEN, and ELSE constructs, as well as the NULL and GOTO statements.

• Chapter 6, Database Interaction and Cursors , describes how to use explicit and implicit cursors.

• Chapter 7, Loops , explains the different types of loops -- LOOP, FOR LOOP, and WHILE LOOP.

• Chapter 8, Exception Handlers , discusses the various types of exceptions, including predefined, named programmer-defined, unnamed internal, and unnamed programmer-defined.

• Chapter 9, Records in PL/SQL , describes how to use table-based, cursor-based, and programmer-defined records.

• Chapter 10, PL/SQL Tables , explains how to declare and use tables, and how to apply them to a variety of tasks.