PL/SQL basics

First, you need to learn the easiest things. This lesson is an introduction to PL/SQL language: you will create tables, insert data, write first blocks, declare variables and use them in code, learn loops and conditional instructions, etc.


In this lesson, you will learn how to use PL/SQL cursors. A cursor is an object pointer to a private SQL area that stores information coming from a SELECT or data manipulation language query (INSERT, UPDATE, DELETE, or MERGE). A cursor holds the rows (one or more) returned by a SQL statement.

Procedures and Functions

In this lesson, you will learn the functions and procedures of PL/SQL language. The PL/SQL function is generally used to compute and return a single value. This returned value may be a single scalar value (such as a number, date or string) or a single collection (such as an array or nested table). Procedures resemble functions in that they are named program units that can be invoked repeatedly. The primary difference is that functions can be used in a SQL statement (for example in SELECT) whereas procedures cannot.


Exceptions are errors during code execution. In this lesson, you will learn how to handle errors.


In this lesson, you will learn about specific PL/SQL objects - packages. Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors.


A trigger is like a stored procedure that Oracle invokes automatically whenever a specified event occurs. These few minutes will be devoted to triggers.

Dynamic SQL and Transactions

In this lesson, you will learn more about PL/SQL: Dynamic SQL and Transactions. These issues cause more difficulties for novice developers, so it's worthwhile to watch this lesson.

Collections and Object Types

Oracle Database allows you to create object-oriented programs. In this lesson, you will learn object types and collections.


When you need to download a lot of data it is worthwhile to get interested in BULK COLLECT.


The last lesson of this course is devoted to specific PL/SQL objects: REF CURSOR and SYS_REFCURSOR.

PL/SQL Video Tutorial For Beginners
Aug 20 2019

Artur M

Oracle is one of the most popular RDBMS (Relational Database Management System). PL/SQL (Procedural Language for SQL) is Oracle procedural extension for SQL. In this tutorial, you will learn the basics of PL/SQL in a few dozen minutes.