Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 12 Weeks Ago, 3 Days Ago |
Questions Answered: | 4870 |
Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Can someone assist me with this 1 pl/sql problem? I need to have it done by tonight if that is possible.
Â
Write a PL/SQL anonymous block that displays three (3) most and three (3) least popularbirthdays along with the ranks for each month. Sort your output in ascending order by months,most popular birthdays, and then least popular birthdays.ï‚·You will lose 10 points if the title lines are missing in your output.ï‚·You will lose 10 points if your output has an incorrect format. For example, you mustdisplay the birthdays and ranks for the same month in one line.ï‚·If you have hard coded the birthdays or ranks (e.g.,DBMS_OUPT.PUT_LINE('1202401426027262'))in your PL/SQL block, you will receive 0points.ï‚·Submitting more thanonePL/SQL program will receive 0 points.Test your program. You must ensure that the output of your program matches the followingoutput (one month per line):
Attachments: