Using Control Structures

This course is included in our On-demand training solution.

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?