Oracle Database 10g: Program with PL/SQL - Level 1

This course has been superseded

We suggest the following instead:
Oracle Database: PL/SQL I Introduction

Course Description

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.

View other Oracle Courses available
2 days
Contact us for pricing
 

Prerequisites

Oracle Database 10g: Introduction To SQL – Complete Library

LANGUAGE FEATURES

Understanding PL/SQL
Structure of a PL/SQL Program Block
PL/SQL from Interactive Tools
Geberating Output within SQL *Plus

DECLARE CLAUSE

About the Declare Clause
Declare Simple Types
Complex Types
Type ... Table
Type ... Record

BEGIN CLAUSE

About the Begin Clause
Performing Data Manipulation
Logic Control & Branching
If-Then-Else
Case

EXCEPTION CLAUSE

About the Exception Clause
Isolating the specific Exeption
Pragma Exception_INIT
SQL%Rowcount & Select ... INTO

EXPLICIT CURSORS

About Explicit Cursors
Advanced Curser Techniques

ADVANCED PROGRAMMING: NESTED BLOCKS

ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS


ISTQB Advanced Test AnalystOracleOracle 10gOracle Database 10g