Introduction of PL/SQL

In this article I am going to explain introduction of PL/SQL.
  • 2249


PL/SQL is define as procedure language/structure query language.  PL/SQL is developed by oracle. PL/SQL supports many feature like variables, loops, conditions  and exceptions. It also support the concept of array. In present time PL/SQL is integrated component of oracle software. SQL provide limited support for advance programming and PL/SQL fill this gap.

PL/SQL provide some advantages

  • Support for SQL
  • Tight integration with Oracle
  • Tight security
  • Higher productivity
  • Full portability
  • Support for object-oriented programming
  • Better performance
  • Error handling

Block is a basic unit of a PL/SQL application. This block is collection of PL/SQL statements grouped as logical unit. Using  PL/SQL blocks you can create five different type of program units.

  1. Stored Function
  2. Stored procedure
  3. Anonymous Block
  4. Trigger
  5. Package

© 2020 DotNetHeaven. All rights reserved.