Wednesday, August 17, 2016

PLSQL - Introduction


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.

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts