Previous | Table of Contents | Next

Page 188

  1. Create a PL/SQL anonymous block that displays the full name of each employee. Please use this format: "Palinski, John".

  2. Create a PL/SQL anonymous block that displays the employees born in a leap year.

  3. Create a PL/SQL anonymous block that causes a no_data_found exception. Display a custom message when this occurs.

  4. Rename the exception in #4 to "No_Record_Found". Display an error message when this exception occurs.

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