Using Control Structures


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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.
  • Course Number:
    217616_eng