Oracle:PL/SQL

From mi-linux
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> Advanced Features >> PL/SQL

Introduction to PL/SQL

PL/SQL is Oracle's extension to SQL that allows the database application developer to write block structured procedural code to interrogate the database. It allows the programmer to define variables and complex control structures.

PL/SQL can be incorporated into the suite of applications that Oracle provide to support application development, such as SQL*Forms. As PL/SQL is available in the Oracle range of products the programmer does not need to learn different facilities for each Oracle product.

The following sections cover PL/SQL very briefly. An extensive examination of PL/SQL is outside the scope of an introductory course in SQL.

It's main use is the development of routines that can be shared by application developers.

Next Step

Database Triggers