|
Provided by: 123-CBT Computer Based Training Using Control Structures |
![]() |
Training
Provided by 123-CBT Computer Based Training
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
|
|
||||||||
Using Control Structures
Overview:
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop constructPre-Requisites:
Familiarity 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 metadataTarget Audience:
Database administrators, application developers, and database operatorsModality:
WEBLesson:
Conditional 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.|
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
-...

