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
115 Minutes

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.


    • Course Number: 217616_eng