If you are looking for a complete PL/SQL tutorial, you are at the right place. This section provides you with a comprehensive PL/SQL tutorial that helps you to learn PL/SQL quickly and easily with a lot of fun.
What is PL/SQL?
PL/SQL stands for Procedural Language extensions to the Structured Query Language (SQL). SQL is a powerful language for both querying and updating data in relational databases. Oracle created PL/SQL that extends some limitations of SQL to provide a more comprehensive solution for building mission-critical applications running on Oracle database. Getting to know more information about PL/SQL language.
Before getting started, it is highly recommended that you setup Oracle database in your system for practicing and learning PL/SQL.
Basic PL/SQL Tutorial
We assume that you have fundamental knowledge of database and SQL to start our PL/SQL tutorial. If this is not the case, you can follow our basic SQL tutorial to have a good start.
This section is targeted as a good starting point for those who are new to PL/SQL. However, if you are very familiar with the language and also want to glance through these tutorials as a refresher, you may even find something useful that you haven’t seen before.
- PL/SQL Block Structure – introduces you to PL/SQL block structure and shows you how to develop the first running PL/SQL program.
- PL/SQL Variables – shows you how to work with PL/SQL variables including declaring, naming and assigning variables.
- PL/SQL Function – explains what PL/SQL functions are and shows you how to create PL/SQL functions.
- PL/SQL Procedure – discusses about PL/SQL procedures and shows you how to create PL/SQL procedures.
- PL/SQL Nested Block – explains what a PL/SQL nested block is and how to apply it in PL/SQL programming.
- PL/SQL IF Statement – introduces you to various forms of the PL/SQL IF statement including
- PL/SQL CASE Statement – shows you how to use PL/SQL
CASEstatement and PL/SQL searched
- PL/SQL LOOP Statement – guides you how to use PL/SQL
LOOPstatement to execute a block of code repeatedly.
- PL/SQL WHILE Loop Statement – executes a sequence of statements with a condition is checked at the beginning of each iteration with the
- PL/SQL FOR Loop Statement – shows you how to execute a sequence of statements in the fixed number of times with
- PL/SQL Exception Handling – teaches you how to handle exception properly in PL/SQL as well as shows you how to define your own exception and raise it in your code.
- PL/SQL Record – explains the PL/SQL record and show you how to use records to manage your data more effectively.
- PL/SQL Cursor – Covers PL/SQL cursor concept and walk you through how to use a cursor to loop through a set of rows and process each row individually.
- PL/SQL Packages – shows you how to create a PL/SQL package that is a group of related functions, procedures, types, etc.