PL/SQL Tutorial

Welcome to the website. I hope that you can consider this website to be an useful resource of pl/sql language for both beginners and advanced developers.
You can read and learn about pl/sql language using simple tutorials with syntax and examples.

About PL/SQL language!

The PL/SQL language is an extension of SQL language developed by Oracle Corporation and the full name it is the Procedural Language/Structured Query Language.

The PL/SQL language is a procedural programming language which allows data manipulation and sql query to be included in blocks. PL/SQL can be used to group multiple instructions in a single block and sending the entire block to the server in a single call.

The main sections on language PL/SQL are:

Data Types – used to declare variables, the basic data types are: number, varchar2, date, clob.
DML Statements – SQL statements like insert, update, delete.
Select Query – contains the main keywords used in SQL queries: where, group by, having, in, order by.
Table Joins – shows the ways to join several tables together.
Stored Procedures – learn how to create and use a stored procedure.
Functions – contains the list with Oracle PL/SQL functions.
Collections and Records – shows how to define and use a collection or record in a database.
Cursors – explain what a cursor is, the types of cursors and how they are used.
Exception Handling – guides you how to use exceptions to handle errors.
Triggers – shows you how to create and modify a trigger on a database table.
Views – syntax to create or replace view.
Indexes – describes how to create an index and the types of indexes.
Constraints – explain how to create constraints such as: primary key, foreign key.
Error Messages – contains the list of error messages, causes and solutions.
Data Dictionary – shows informations about the schema objects.
Synonym – syntax to create synonyms.
Interview Questions and Answers – list with interview questions and answers.
Aggregate functions – contains aggregate functions like avg, count, sum, max, min.
Analytic functions – contains analytic functions like row_number, rank, dense_rank, listagg.
Conversion functions – contains conversion functions like cast, to_number, to_char, to_date.
Date functions – describes date functions like sysdate, date, add_months, day, year.
String functions – learn about string functions like concat, length, lower, upper, replace, substr.
REGEXP – introduction to SQL regular expressions functions.
Packages – can be used to encapsulate data and hide implementation details.
JSON – used to parse JSON data, create JSON documents, and extract data from JSON documents.
XML – describes how to manipulate and store XML documents.
Tables in SQL – A Complete Guide – shows how to define tables in SQL.
Dynamic SQL – allows you to construct a SQL statement based on runtime conditions, such as user input or data in a table, and then execute that statement.
Advanced SQL Techniques for Data Engineering – contains advanced SQL techniques for Data Engineering: Window Functions, Common Table Expressions, and more.

PL/SQL is composed of logical blocks, the main types of blocks are:

– Anonymous blocks are block unnamed and not forming the body of a procedure, function or trigger;
– Blocks of type function and procedure;
– Blocks trigger – contains the PL/SQL code to be executed when certain actions or events occurring in the database;
– Nested blocks – used to handle errors.

Programming resources:

T-SQL tutorial
Oracle tutorial