Home

PL/SQL (Procedural Language Extension of SQL) Tutorial, Articles

Latest Articles, Tutorials, Examples on PL/SQL

1. Introduction to PL / SQL in DBMS.
   PL/SQL Introduction: Here, we are going to learn about the PL/SQL, introduction to PL/SQL, features of PL/SQL, advantages and disadvantages of PL/SQL.
2. Block Structure of PL/SQL in DBMS.
   In this tutorial, we are going to learn about the block structure of PL/SQL in the DBMS (database management system).
3. Looping in PL/SQL (Procedural Language Extension of SQL).
   In this article we will learn about different types of loops in PL/SQL, their syntaxes and executions.
4. Case Statements in PL/SQL.
   PL/SQL - Case statements in PL/SQL: In this article, we will learn about case statement (similar as switch case statements in C/C++) with examples.
5. How to input from user in PL/SQL?
   In this article we learn how to take input from user. Just like we use scanf function in C and cin in C++, We will learn how to do the same thing in PL/SQL?
6. Strings in PL/SQL - 1 (Types of string with Example).
   In this article, we are going to learn about the strings and its type in PL/SQL, we will learn about fixed length string, variable length string and character large object.
7. Strings in PL/SQL - 2 (Functions with Examples).
   In this article, we are going to learn about the strings in PL/SQL and it’s some of the important functions which may help us to manipulate strings in PL/SQL in a better way.
8. Arrays in PL/SQL (with its properties, syntaxes and examples).
   In this article, we are going to learn an important topic in PL/SQL that is VARRAY DATA STRUCTURE. This data Structure is very important in any programming language. So let’s learn its behaviour in PL/SQL.
9. Procedure in PL/SQL to find minimum of 2 numbers.
   Here, we are going to learn how to write a Procedure in PL/SQL to find minimum of 2 numbers?