Pages

Search

 

02 August 2009

[Oracle] Adding PL/SQL Functionality into an Application



What Is PL/SQL?

PL/SQL stands for Procedural Language extension to SQL. The language offers a robust programming environment that enables you to program procedurally and/or with object-oriented programming techniques such as encapsulation, information hiding, and function overloading. With PL/SQL, you can use state-of-the-art programming for the Oracle Database server and toolset.

Why Use PL/SQL?
PL/SQL provides procedural constructs such as variables, constants, and types. The language provides selective and iterative constructs to SQL. The following are the major benefits of using PL/SQL :
  • Integration of procedural constructs with SQL
  • Reduction in network congestion
  • Modularized program development
  • Integration with tools
  • Portability
  • Exception handling

You may find it necessary to use database applications that include programming logic, sequential statements, and SQL statements. Using PL/SQL, you can build applications that are resilient to change over time and that scale to large user populations.

Source : Oracle Curriculum

No comments: