Wednesday, 29 April 2015

Introduction Of PL/SQL

By
PL/SQL is programming language was developed by Oracle Corporation in the late 1980s. PL/SQL stands for procedural language extension of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages.

You can use PL/SQL to implement your bussiness rules by creating stored function, procdures and triggers or you can add programming logic to the SQL commands. PL/SQL have a one of the most important functionality to display multiple records from the multiple tables at the same time. In short PL/SQL is a completely portable, high-performance transaction-processing language.

Advantages Of PL/SQL :-

It is provide high security level.
It provide support for OOP(Object Oriented Programming).
It provide block structure.
It provides Exception Handling.
Better Performance
Platform Independent
Reduce the network traffic.


0 comments:

Post a Comment