PL/SQL Tutorial

PL/SQL Tutorial Overview

PL/SQL stands for Procedural Language extension of structured query language. PL/SQL is a combination of SQL along with the procedural programming languages features like declaring and using constants, variables,etc.... In early 90's PL/SQL was developed by Oracle Corporation to enhance the capabilities of SQL. 

 

In PL/SQL tutorial we covered complete topics from basic to advanced level those are

 

  1. PL/SQL Environment Setup
  2. PL/SQL Datatypes
  3. PL/SQL Operators
  4. PL/SQL Database Operations
  5. PL/SQL Functions
  6. PL/SQL Constants
  7. PL/SQL Cursors
  8. PL/SQL Triggers
  9. PL/SQL Exception Handling
  10. PL/SQL Loops
  11. PL/SQL Procedures…and many more topics in PL/SQL

Audience

PL/SQL tutorial is targeted for beginners as well as experienced people who is having basic knowledge on RDMBS and Databases. In PL/SQL tutorial we covered all topics from basic to advanced level which will give clear idea to use PL/SQL in applications with examples.

Prerequisites

Before proceeding with PostgreSQL tutorial you should have some basic knowledge on database programming and RDBMS then it will be very easy for you to understand PL/SQL topics.