Course Details

Previous Page


Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures


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



Overview/Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.3

Lesson Objectives

Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures

  • recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements.
  • identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block.
  • recognize the steps for writing and identifying loop statements.
  • create PL/SQL blocks that incorporate loops and conditional control structures.
  • Course Number:
    260270_eng