Oracle Database: Introduction to PL/SQL is a beginner course in Oracle's PL/SQL language on Oracle AI Database 26ai, from blocks, variables, conditions and loops to cursors, exception handling and stored procedures and functions, with labs based on real tasks. It suits developers, database staff and SQL users who want to write programs inside Oracle databases.
Much of the work in organisations that run Oracle Database involves multi-step data processing, such as payroll calculations, end-of-day closing or moving data between tables. Written as one SQL statement at a time from the application side, this work is slow, hard to maintain and can leave data half-finished when something fails. PL/SQL is Oracle's procedural language, and it lets you run this logic inside the database in one place, with transactions and errors handled properly.
This course lays the foundations of PL/SQL on Oracle AI Database 26ai, Oracle's current release. Learners set up the free edition with SQL Developer for VS Code and SQLcl, then learn anonymous block structure, variables and data types including BOOLEAN, which now works in both SQL and PL/SQL, retrieving data, managing transactions, conditions and loops. The course continues with records, collections, cursors, BULK COLLECT and FORALL, exception handling, and creating stored procedures and functions. Every topic has a lab based on real tasks, and the course closes with a workshop that builds a data processing job from start to finish. (2 days, 6 hours per day, 12 hours in total, Beginner level.)
Course Details
This course is the 2026 edition of Oracle Database: Introduction to PL/SQL, updated for Oracle AI Database 26ai, the current release that succeeds 23ai. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with a lab for every topic. Beginner level. Learners install Oracle AI Database 26ai Free on their own machine and write code with SQL Developer for VS Code and SQLcl. The course covers language basics, transactions, collections, cursors, BULK COLLECT, exceptions and stored procedures, and most of the code also runs on Oracle Database 19c. Learners take home a lab guide, SQL and PL/SQL scripts for every lab, and the workshop code.
Section 1: Lab: Setting Up Oracle AI Database 26ai
Section 2: Anonymous Block Structure
Section 3: Variables and Data Types
Section 4: Lab: Retrieving Data and Managing Transactions
Section 5: Lab: Conditions and Loops
Section 6: Functions and Data Type Conversion
Section 7: Records and Collections
Section 8: Lab: Explicit Cursors
Section 9: Lab: Processing Large Volumes of Data
Section 10: Handling Exceptions Systematically
Section 11: Lab: Stored Procedures and Functions
Section 12: Workshop: The Execution Environment and Final Project
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
SQL issues individual statements to the database, such as SELECT, INSERT and UPDATE. PL/SQL is Oracle's procedural language built around SQL, adding variables, IF conditions, loops, exception handling and stored procedures and functions. It lets you run multi-step business logic inside the database in one go, reducing round trips between the application and the server.
An anonymous block has four parts: DECLARE for variables and cursors (optional), BEGIN for the executable statements (required), EXCEPTION for error handling (optional), and END; to close it. In SQLcl or SQL Developer for VS Code, type / to run it, and use SET SERVEROUTPUT ON to see the output from DBMS_OUTPUT.PUT_LINE.
Declare the cursor with its SELECT statement in the DECLARE section, OPEN it, then FETCH ... INTO inside a loop to read one row at a time, exit when %NOTFOUND is true and CLOSE it. A cursor FOR loop does the opening, fetching and closing for you. For large volumes, fetch in batches with BULK COLLECT and LIMIT and write the results with FORALL, which cuts context switches between the SQL and PL/SQL engines and is much faster than row-by-row processing.
It suits developers, staff who look after Oracle databases, and SQL users who want to write logic inside the database. You should know basic SQL such as SELECT, JOIN, INSERT and UPDATE. No programming experience is required, and you should bring a laptop that can run Docker Desktop or a VM and VS Code for the labs.
You will be able to set up Oracle AI Database 26ai Free yourself, write anonymous blocks with variables and data types, manage transactions, write conditions and loops, use records, collections and cursors, process large volumes with BULK COLLECT and FORALL, handle exceptions with logging, and create, call and drop stored procedures and functions. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as writing procedures for the data processing your team already handles. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Articles are published in Thai.
Many problems in business systems start with the database structure: duplicated data that is changed in one place but not another, reports that pull figures that do not match, or systems where new features are hard to add because the tables were related…
The data in an Oracle database is often the heart of an organisation's systems, yet many sites still have backups that have never been test-restored, do not know whether they can roll data back to before a mistake, and have no clear procedure for when a disk…
