·         Introduction to PL/SQL

PL/SQL Overview

Benefits of PL/SQL Subprograms

Overview of the Types of PL/SQL blocks

Create a Simple Anonymous Block

Generate Output from a PL/SQL Block

·         Standard Functions

General functions

Number functions

Other functions

·         PL/SQL Identifiers

List the different Types of Identifiers in a PL/SQL subprogram

Usage of the Declarative Section to define Identifiers

Use variables to store data

Identify Scalar Data Types

The %TYPE Attribute

What are Bind Variables?

Sequences in PL/SQL Expressions

·         Write Executable Statements

Describe Basic PL/SQL Block Syntax Guidelines

Comment Code

Deployment of SQL Functions in PL/SQL

Converting Data Types

Nested Blocks

Identify the Operators in PL/SQL

·         Interaction with the Oracle Server

Invoke SELECT Statements in PL/SQL to Retrieve data

Dynamic SQL

Data Manipulation in the Server Using PL/SQL

SQL Cursor concept

Usage of SQL Cursor Attributes to Obtain Feedback on DML

Save and Discard Transactions

·         Control Structures

Conditional processing Using IF Statements

Conditional processing Using CASE Statements

Use simple Loop Statement

Use While Loop Statement

Use For Loop Statement

Describe the Continue Statement

·         Composite Data Types

Use PL/SQL Records

The %ROWTYPE Attribute

Insert and Update with PL/SQL Records

Associative Arrays (INDEX BY Tables)

Examine INDEX BY Table Methods

Use INDEX BY Table of Records

·         Explicit Cursors