Using PL/SQL with an Oracle Server


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


Overview/Description
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block

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)
2.0

Lesson Objectives

Using PL/SQL with an Oracle Server

  • write lexical units in their correct format in a PL/SQL block.
  • perform data conversion in PL/SQL.
  • use qualifiers to access and evaluate variables in PL/SQL blocks.
  • convert and evaluate variables in PL/SQL.
  • use a SELECT statement in a PL/SQL block to retrieve data from a database.
  • use implicit SQL cursor attributes to determine the outcome of DML commands.
  • use PL/SQL to perform database operations and use SQL cursor attributes to evaluate results.

    • Course Number:
    216530_eng