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