Question: PL / SQL : Use the classes table (Student Administration db). Code a loop that repeats 6 times for class_id = 1 to 6 and

PL / SQL :

Use the classes table (Student Administration db). Code a loop that repeats 6 times for class_id = 1 to 6 and displays the class id, period, and one of the statements below. Include appropriate labels. Use CASE (nested inside the loop).

If the period is:

first Set the alarm and get up early.

second OK to sleep an extra hour.

third Take your time in the morning.

fourth Who needs lunch anyway?

fifth Im too tired in the afternoon to do any work!

-- If the period is not one of the words above, the statement to display is Unknown period. What time of day is that?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!