Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 5 Test Your Thinking

In this chapter you learned about different types of IF statements. You also learned that all of these different IF statements can be nested one inside another. Here are some exercises that will help you test the depth of your understanding.

1)	Rewrite ch05_1a.sql. Instead of getting information from the user for the variable v_date, define its value with the help of the function SYSDATE. After it has been determined that a certain day falls on the weekend, check to see if the time is before or after noon. Display the time of the day together with the day.
2)	Create a new script. For a given instructor, determine how many sections he or she is teaching. If the number is greater than or equal to 3, display a message ...