Oracle Database 11g: Getting Started With PL/SQL

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
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.9

Lesson Objectives

Oracle Database 11g: Getting Started With PL/SQL

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