PL/SQL Tutorial

Welcome to the PLSQL.co 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.
Interview Questions and Answers – list with interview questions and answers.

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