Course Outline

Introduction to PL / SQL

  • Runtime Environment
  • Construction and types of PL / SQL blocks
  • Declaring and using variables
  • Control statements, decisions, loops

SQL statements in PL / SQL

  • DML commands
  • DDL and dynamic SQL
  • TCL commands and transactional

Procedures and Functions

  • Create and delete
  • Parameterization
  • Passing parameters by value and reference, nocopy

Handling errors and exceptions

Create and use cursors

  • Records
  • static cursors
  • Parameterizing cursors
  • Cursor FOR UPDATE

Associative arrays


  • The structure of the package: the specification and body
  • Section Initialization and global variables, memory management, an instance of the package
  • Encapsulation, overloading programs, pre-declaration procedures


  • DML triggers
  • The triggers Drives (INSTEAD OF)
  • The triggers system
  • New features in Oracle 11g triggers

Examples of application packages built

  • Writing to a file through UTL_FILE
  • Sending e-mails

Management code and compiler

  • Encryption code (dynamic obfuscation, wrap)
  • conditional Compilation
  • The relationships between objects
  • Warnings


  • Basic skills in any programming language, object-oriented structural or
  • The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
  28 Hours


Related Courses

SQL in Microsoft Access

  14 hours

Microsoft Access - download the data

  14 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Basic

  14 hours

Transact SQL Advanced

  7 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours


  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Oracle SQL Language

  14 hours

Oracle SQL for beginners

  21 hours

Oracle SQL Advanced

  14 hours

Developing Applications with Oracle Application Express (APEX)

  21 hours