Learn To Code Ninja

Free technical booklets — download and learn.

Part 1 of 4 in the Oracle & PL/SQL path

Beginners Guide to Learning PLSQL booklet cover

Beginners Guide to Learning PLSQL

PDF 458 KB Beginner Sep 2026

New to Oracle databases? This beginner-friendly guide introduces PL/SQL from the ground up: no prior Oracle experience assumed. Work through hands-on examples from your first anonymous block to reusable procedures and functions.

What you'll learn

  • Write your first PL/SQL anonymous blocks
  • Work with variables, data types, and control structures
  • Fetch and process data with cursors
  • Build reusable procedures, functions, and packages
Download booklet (PDF, 458 KB)

Table of contents

  1. What Is PL/SQL & Why Learn It
  2. Setting Up Your Oracle Environment
  3. Anonymous Blocks: Your First Programs
  4. Variables & Data Types
  5. Control Structures: IF, CASE & Loops
  6. Working with Cursors
  7. Writing Stored Procedures
  8. Writing Functions
  9. Introduction to Packages
  10. Exception Handling Basics

You may also like

SQL Server Essentials booklet cover SQL Server Essentials Introduction to Autosys booklet cover Introduction to Autosys Introduction to BASH Scripts booklet cover Introduction to BASH Scripts