Chapter 7 Test Your Thinking
In this chapter you learned about built-in exceptions. Here are some projects that will help you test the depth of your understanding.
| 1) | Create the following script: Check to see whether there is a record in the STUDENT table for a given student ID. If there is no record for the given student ID, insert a record into the STUDENT table for the given student ID. |
| 2) | Create the following script: For a given instructor ID, check to see whether it is assigned to a valid instructor. Then check the number of sections that are taught by this instructor and display this information on the screen. |
The projects in this section are meant to have you utilize all of the skills that you have acquired throughout this chapter. The ...
Get Oracle® PL/SQL® Interactive Workbook, Second Edition 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.
