I need the SQL code for these qustions
Posted: Tue Jul 12, 2022 8:10 am
I need the SQL code for these qustions
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)
- I Need The Sql Code For These Qustions 1 (15.56 KiB) Viewed 64 times
- I Need The Sql Code For These Qustions 2 (13.81 KiB) Viewed 64 times
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)