Introduction to PL/SQL

Overview/Description
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL

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
135 Minutes

Objectives:

Introduction to PL/SQL

  • recognize the correct structure of a PL/SQL program block.
  • use iSQL*Plus to display the output of a PL/SQL anonymous block.
  • declare and initialize a variable in a given scenario.
  • declare and initialize scalar data types and Boolean variables.
  • declare and initialize scalar types.
  • use bind and substitution variables and the DEFINE command to assign values in PL/SQL code.
  • match the composite and LOB data types with their associated functionality.
  • pass runtime values in and out of PL/SQL code.


    • Course Number: 216518_eng