June 28, 2017

Oracle PL SQL Features Advantages Enhancements


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.


Subscribe to get more Posts :