Monday, 28 September 2015



What is PL/SQL


PL/SQL stands for procedural Language extension of SQL. PL/SQL is the combination of the SQL along with the some procedural features of programing language. The PL/SQL is the developed by the ORACLE Corporation for improving the ability of the SQL.

Main Features of the PL/SQL

1: It Combine the Data manipulating power of SQL with the power of procedural Language.
2: We can define, variable, Procedures, and functions in Pl/SQL.
3: We can break complex problems into easily understandable procedural code.
4: Code can be reused for multiple applications.

There are many advantage of the PL/SQL

Block Structures
Procedural Language Capability
Better Performance
Error handling
Portable and Transaction Processing Language


No comments:

Post a Comment