|
Provided by: 123-CBT Computer Based Training Explicit Cursors and Exception Errors |
 |
Explicit Cursors and Exception Errors Oracle
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Explicit Cursors and Exception Errors
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
LessonsRetrieving data with explicit cursors| - use explicit cursors to retrieve data.|Processing data with explicit cursors| - process data using records, cursor attributes, and cursor FOR loops.|Cursors with parameters| - use parameters to make cursors reusable in a given scenario.|Using FOR UPDATE and WHERE CURRENT OF| - use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows.|Working with explicit cursors| - use an explicit cursor to retrieve and update data.|Exceptions in PL/SQL| - outline how each of the PL/SQL exception types are raised and handled.|Trapping predefined and non-predefined exceptions| - trap predefined and non-predefined exceptions in PL/SQL.|Trapping user-defined exceptions| - trap user-defined exceptions and identify error codes and messages.|Exceptions in nested blocks and procedures| - use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL.|Handling exceptions in PL/SQL blocks| - handle exceptions 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
-...
