Home / Definitions / PL/SQL

PL/SQL

Webopedia Staff
Last Updated May 24, 2021 7:52 am
Short for Procedural Language/SQL, Oracle s procedural extension to the industry-standard SQL. By adding procedural constructs to SQL, such as encapsulation, function overloading, information hiding, block structure, conditional statements, loop statements, variable types, structured data and customized error handling, the PL/SQL language takes on characteristics of object-oriented programming languages. PL/SQL’s language syntax, structure and data types are similar to that of the Ada programming language. Integrated with a database server, PL/SQL does not exist as a standalone language. It typically is used to write data-centric programs to manipulate data in an Oracle database.