Difference between revisions of "Oracle:PL/SQL"
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
− | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> [[Oracle:Advanced Features|Advanced Features]] PL/SQL | + | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> [[Oracle:Advanced Features|Advanced Features]] >> PL/SQL |
== Introduction to PL/SQL == | == Introduction to PL/SQL == | ||
Line 13: | Line 13: | ||
== Next Step == | == Next Step == | ||
− | [[Oracle:Database Triggers|Triggers]] | + | [[Oracle:Database Triggers|Database Triggers]] |
Latest revision as of 16:44, 23 June 2016
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.