August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 1: | Create a “division by zero” error. Trap the error, and display the appropriate message for the user. |
| 2: | Create a program that inserts a record into the Emp_tools table. The record should contain an employee ID that does not exist in the Employee table. Trap and handle this error. |
| 3: | Change the error handler in Question 2 to the OTHERS handler. |
| 4: | Use the OTHERS, SQLCODE, and SQLERRM methods to trap and display information about a “no data found” error. |
| 5: | Create a procedure that retrieves the State value for Clinton. If the value is not equal to NJ, use the exception section to display a message. |
| 6: | You need to create a listing that retrieves values from two tables. One of the tables has only a small number of values. Rather than joining ... |