Oracle PL/SQL Training covers the following topics:

Introduction

  • Identifiers, comments
  • Operators

Basics

  • Anonymous block
  • Types of data
  • Embedded SQL
  • Records
  • Visibility and consignment
  • Cursors
  • Bounded variables
  • Dynamic SQL

Control Structures

  • Conditional instructions
  • Loops
  • Collections

Stored sub-programs

  • Stored procedures
  • Stored functions
  • Packages

Debugging