I Need The Sql Code For These Qustions 1 (15.56 KiB) Viewed 63 times
I Need The Sql Code For These Qustions 2 (13.81 KiB) Viewed 63 times
Q5. Write a pl/sql function for the following details: [20 points) Players (Playerid, FirstName, LastName, JerseyNo, TotalGoals Scored, MarketValue, Clubid) Club (Clubid, ClubName, ClubAddress, ClubEstablished Year) Using the two tables above, write a function that will take Club Name (text) and number of goals scored (number) as an input parameter, returns the total number of players in that club who scored more than the number goals entered.
Q6. Write an anonymous pl/sql block and call the function you wrote in Q5 by getting the category name and price from the user. You will get these two inputs from the user and call the function you wrote in Q5, save the result returned from the function into a variable and print it properly to the user. Make sure to include all necessary exception handlings. (15 points)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!