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 ... |
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
