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

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

Prerequisite
Previous programming experience and knowledge of SQL

Expected Duration
80 minutes

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.

Objective

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



     

    NEED HELP OR NOT SURE?