Why Learn It?
  Adding PL/SQL Functionality into an Application
Previous previous|next Next Page

In this module, you will learn how to use PL/SQL code to enhance functionality in your 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, function overloading. With PL/SQL, you can use state-of-the-art programming to the Oracle Database server and toolset.

Why PL/SQL?
PL/SQL provides procedural constructs such as variables, constants and types. The language provides selective and iterative constructs to SQL. 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 scale to large user population. Now that Sheila has to work on the HR application, you will watch her add PL/SQL functionalithy into the application. You will watch Sheila create procedures, functions and triggers.