Using Control Structures

Overview/Description
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
1.9

Lesson Objectives

Using Control Structures

implement a suitable conditional control statement in PL/SQL for a given scenario.

implement simple and searched CASE expressions and statements in PL/SQL.

identify the situations that can cause errors when handling nulls in PL/SQL.

implement suitable control structures in PL/SQL.

implement a suitable loop construct in PL/SQL for a given scenario.

identify the characteristics of FOR and nested loops in PL/SQL.

implement suitable loop structures in PL/SQL.