PL/SQL Features


Prev Tutorial Next Tutorial

PL/SQL Features

It have number of advantage over sql like it have error handling mechanism, reduce network traffic, better performance, highly secure, code re-usability.

sql
  • 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.

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements