Friday, 13 October 2017

Introduction to PL/SQL

  • PL/SQL stands for “Procedural Language extension to SQL”. It is tightly integrated with SQL.
  • PL/SQL is Oracle Corporation’s standard data access language for relational databases.
  • PL/SQL provides a block structure for executable units of code. Here maintenance of code is made easier with a very well-defined structure.
  • PL/SQL seamlessly integrates procedural constructs with SQL. It provides procedural constructs such as:
    • Variables, constants, and data types
    • Control structures such as conditional statements and loops
    • Reusable program units that are written once and executed many times
  • PL/SQL offers modern software engineering features such as data encapsulation, exception handling, information hiding, and object orientation. It brings state-of-the-art programming to the Oracle Server and tool set.