Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

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 ...