Introduction (PL/SQL)

The PL/SQL programing language was developed by Oracle Corporation within the late 1980s as procedural extension language for SQL and therefore the Oracle electronic database . Following are notable facts about PL/SQL:

• • • PL/SQL is a completely portable, high-performance transaction-processing language.
  • PL/SQL provides a built-in interpreted and OS(Operating System) independent programming environment.
  • PL/SQL also can directly be called from the command-line SQL*Plus interface.
  • Direct call also can be made up of external programing language calls to database.
  • PL/SQL’s general syntax is predicated thereon of ADA and Pascal programing language .
  • Apart from Oracle, PL/SQL is out there in TimesTen in-memory database and IBM DB2.

  Features of PL/SQL

  PL/SQL has the following features:

  • • PL/SQL is tightly integrated with SQL.
    • It offers extensive error checking.
    • It offers numerous data types.
    • It offers a variety of programming structures.
    • It supports structured programming through functions and procedures.
    • It supports object-oriented programming.
    • It supports developing web applications and server pages.
  • Advantages of PL/SQL

  Advantages of PL/SQL

  PL/SQL has the following advantages:

  • • SQL is that the standard database language and PL/SQL is strongly integrated with SQL. PL/SQL supports both static and dynamic SQL.
• PL/SQL allows sending a whole block of statements to the database at just one occasion . This reduces network traffic and provides high performance for the applications.
• PL/SQL gives high productivity to programmers because it can query, transform, and update data during a database.
• PL/SQL saves time on design and debugging by strong features, like exception handling, encapsulation, data hiding, and object-oriented data types.
• Applications written in PL/SQL are fully portable.
• PL/SQL provides high security level.
• PL/SQL provides access to predefined SQL packages.
• PL/SQL provides support for Object-Oriented Programming.
• PL/SQL provides support for Developing Web based Applications and Server Pages.

CHARACTERSTICS

• Highly structured, readable and accessible language.
• Standard and Portable language.
• Embedded language.
• Improved execution authority.