| WA1475 Oracle Database 10g: Program With PL/SQL Part I Training and Courseware |
|
| Description |
|
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.
|
|
| Course Objectives: |
|
The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle10g Release 2 (R2) revision. Major subject areas to be explored are:
- Understand the environment and context in which PL/SQL operates.
- Consider the advantages and benefits of PL/SQL within a database environment.
- Declaring program variables and complex data types.
- Developing logic within PL/SQL program blocks.
- Fetching data from the database into program variables.
- Returning program output to users.
- Handling program exceptions.
- Using explicit and implicit database cursors.
- Using the advanced features of nested blocks and subprograms.
- How to take advantage of new features such as regular expression support and the handling of string literals within program code
|
|
| Target Audience: |
|
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and developers.
- Database administrators
|
|
| Duration: |
| |
Two days. |
|
|
|
|
