Oracle Database: PL/SQL I - Introduction Training

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming course series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.
Course Details


3 days


Oracle Database 12c: SQL Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II, & III) or equivalent experience.

Target Audience

  • Application Designers
  • Database Developers
  • Database Administrators
  • Web Server Administrators

Skills Gained

  • Learn how to build executable PL/SQL program units
  • Understand error or exception handling capabilities
  • Explore techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications
Course Outline
  • Selection & Setup Of The Database Interface
    • Considering Available Tools
    • Selecting The Appropriate Tool
    • Oracle NET Database Connections
    • Oracle PAAS Database Connections
    • Setup SQL Developer
    • Setup SQL*PLUS
    • Setup JDeveloper
  • About BIND & SUBSTITUTION Variables
    • Using SQL Developer
    • Using SQL*PLUS
  • Choosing A Database Programming Language
    • What Is Database Programming?
    • PL/SQL Performance Advantages
    • Integration With Other Languages PL/SQL Language Fundamentals
    • PL/SQL Program Structure
    • Language Syntax Rules
    • Embedding SQL
    • Writing Readable Code
    • Generating Database Output
    • SQL*PLUS Input Of A Program Block
  • DECLARE Section
    • About The DECLARE Section
    • DECLARE Primitive Types
    • Declaration Options
    • NOT NULL
    • Data Dictionary Integration
    • %TYPE
    • Declare Simple User-­‐Defined Types
    • TYPE ... TABLE
    • TYPE ... RECORD
    • Extended User-­‐Defined Types
  • BEGIN  Section
    • About The BEGIN Section
    • Manipulating Program Data
    • Logic Control & Branching
    • GOTO
    • LOOP
    • IF-­‐THEN-­‐ELSE
    • CASE
  • Exception Section
    • About The EXCEPTION Section
    • Isolating The Specific EXCEPTION
    • SQLCODE & SQLERRM Example
    • SQL%ROWCOUNT & SELECT...INTO Beyond The Basics:
  • Explicit Cursors
    • About Explicit Cursors
    • Extended Cursor Techniques
    • FOR UPDATE OF Clause
    • Using FOR…LOOP Cursors
  • Beyond The Basics: Nested Blocks
  • Beyond The Basics: DECLARED Subprograms
    • Using DECLARED Subprograms
    • DECLARED Procedure
    • DECLARED Function