PLSQL Introduction
PLSLQL is a
procedural extension to SQL (Structured Query Language).
A language
to access/process data in Oracle Database
Like any
other programming language, PLSQL
provides procedural constructs such as variables, constants, data types, procedural
constructs, OOPS concepts, collections, error handling.
It has a
block like structure, which makes code maintenance easier.
It has PLSQL
compiler for compilations of programs.
It has
reusable programs which can be compiled once executed many times.
It has PLSQL
engine where PLSQL statements are executed.
It logically
combines SQL statements into one unit, which improves performance when multiple
SQL statements are execute as a single
unit.
