Question: Question 1 Write a PL / SQL program that prompts the student to enter a month number ( 1 - 1 2 ) and displays

Question 1
Write a PL/SQL program that prompts the student to enter a month number (1-12) and
displays the corresponding month name. The program should utilize a case statement to
determine the month name based on the input month number.
Enter value for month_number: 2
Please enter a month number (1-12):
The corresponding month name is: February
PL/SQL procedure successfully completed.
SQL>/
Enter value for month_number: 14
Please enter a month number (1-12):
The corresponding month name is: Invalid
month number
PL/SQL procedure successfully completed.
 Question 1 Write a PL/SQL program that prompts the student to

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!