Using PL/SQL with an Oracle Server

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.