Difference between revisions of "Oracle:Advanced Features"
| Line 2: | Line 2: | ||
Note this section covers some of the more advanced features of SQL. It is not essential to the module that you complete this section, so only continue if you have time. | Note this section covers some of the more advanced features of SQL. It is not essential to the module that you complete this section, so only continue if you have time. | ||
| + | |||
| + | == 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. | ||
| + | |||
| + | The following sections use PL/SQL very briefly. An extensive examination of PL/SQL is outside the scope of an introductory course in SQL. Its main use is the development of routines that can be shared by application developers. | ||
This section covers an introduction to the following topics: | This section covers an introduction to the following topics: | ||
| − | |||
*[[Oracle:Database_Triggers|Database Triggers]] | *[[Oracle:Database_Triggers|Database Triggers]] | ||
*[[Oracle:Database_Procedures|Database Procedures]] | *[[Oracle:Database_Procedures|Database Procedures]] | ||
Latest revision as of 16:48, 23 June 2016
Main Page >> Oracle and SQL >> Workbook >> Advanced features
Note this section covers some of the more advanced features of SQL. It is not essential to the module that you complete this section, so only continue if you have time.
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.
The following sections use PL/SQL very briefly. An extensive examination of PL/SQL is outside the scope of an introductory course in SQL. Its main use is the development of routines that can be shared by application developers.
This section covers an introduction to the following topics:
Return to the Workbook.
