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

Basic PL/SQL Tutorial

This block is mainly designed for the candidates who are new to the programming section with respect to sql

  • Block Structure
  • Variables
  • Function
  • Procedure
  • Nested Block
  • IF Statement
  • CASE Statement
  • LOOP Statement
  • WHILE Loop Statement
  • FOR Loop Statement
  • Exception Handling
  • Record
  • Cursor
  • Packages