PL SQL have many advantage over sql like it have error handling mechanism, reduce network traffic, better performance, highly secure, code re-usability.
High performance: PL/SQL is high performance transaction processing language.
Code Re-usability: It support code re-usability, it means no need to write code again and again same like SQL.
Error Handling: when any error are occurred then it return user friendly error message.
Procedural Language Capability: It consists of procedural language constructs such as conditional statements (if...else) and loops statements (for loop)
Block Statement: It consists of blocks of code, which can be nested within each other. Each and every block forms a unit of a task or a logical module.
Better performance: oracle engine processes multiple SQL statements simultaneously as a single block, due to this reducing network traffic.
Declare variable: It give you control to declare variable and access them within the block.
It support looping and conditional statements
Reduce Network Traffic: oracle engine processes multiple SQL statements simultaneously as a single block, due to this reducing network traffic.
Portable application: Applications are written in PL/SQL are portable in any available Operating system.
High performance: PL/SQL is high performance transaction processing language.
Code Re-usability: It support code re-usability, it means no need to write code again and again same like SQL.
Error Handling: when any error are occurred then it return user friendly error message.
Procedural Language Capability: It consists of procedural language constructs such as conditional statements (if...else) and loops statements (for loop)
Block Statement: It consists of blocks of code, which can be nested within each other. Each and every block forms a unit of a task or a logical module.
Better performance: oracle engine processes multiple SQL statements simultaneously as a single block, due to this reducing network traffic.
Declare variable: It give you control to declare variable and access them within the block.
It support looping and conditional statements
Reduce Network Traffic: oracle engine processes multiple SQL statements simultaneously as a single block, due to this reducing network traffic.
Portable application: Applications are written in PL/SQL are portable in any available Operating system.
Post a Comment