Previous | Table of Contents | Next
Page
188
- Create a PL/SQL anonymous block that displays the full name of each employee.
Please use this format: "Palinski, John".
- Create a PL/SQL anonymous block that displays the employees born in a leap year.
- Create a PL/SQL anonymous block that causes a
no_data_found exception. Display a custom message when this occurs.
- Rename the exception in #4 to "No_Record_Found". Display an error message when
this exception occurs.
- Create your own custom exception that displays an exception message when
the program encounters an employee whose first name is "Franklin".
Previous | Table of Contents | Next
|