|
Provided by: 123-CBT Computer Based Training Using Control Structures |
 |
Using Control Structures Oracle
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Using Control Structures
Oracle
PrerequisitesFamiliarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Target AudienceDatabase administrators, application developers, and database operators
LessonsConditional statements| - implement a suitable conditional control statement in PL/SQL for a given scenario.|CASE statements and expressions| - implement simple and searched CASE expressions and statements in PL/SQL.|Handling nulls in PL/SQL| - identify the situations that can cause errors when handling nulls in PL/SQL.|Working with control structures| - implement suitable control structures in PL/SQL.|Loop basics| - implement a suitable loop construct in PL/SQL for a given scenario.|FOR and nested loops| - identify the characteristics of FOR and nested loops in PL/SQL.|Working with loops| - implement suitable loop structures in PL/SQL.|
Test Prep
Simulations
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
