Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration (hours)
1.9

Lesson Objectives

Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.

identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.

identify the steps for declaring and initializing PL/SQL variables.

identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.

identify the steps for constructing executable statements using various PL/SQL block elements.

evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.