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 (hours)
2.2

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