Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle Introduction: PL/SQL Cursors and Exceptions |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Trainee database administrators and application developers |
| Prerequisites |
| Familiarity with programming techniques would be an advantage |
| Course Aim |
| To explain the concept of a composite database, and to show how to use cursors and handle exceptions in PL/SQL |
| Learning Objectives |
| Explain PL/SQL records and tables. Manipulate explicit cursors. Use cursor FOR loops. Explain the different types of exceptions. Trap and handle exceptions. |
| Topics Covered |
| Composite datatypes - PL/SQL records - PL/SQL tables - Hands-on: Creating a PL/SQL table Explicit cursors - Controlling cursors - Cursor attributes - Advanced cursor usage - Hands-on: Creating a PL/SQL block Handling exceptions - Trapping Oracle server errors - User-defined exceptions - Hands-on: Creating and invoking exceptions |