Answer Happy

Task 2 (2.0 marks) PLSQL Function Implement a stored PL/SQL function CustWith HighestOrder that finds the details of customer who has made the highest number of orders. The function is not required to accept any parameter. The function is to automatically find the details of the customer and returns a string of characters that contains the customer key, customer name, customer address, customer telephone and the number of orders made. Execute the stored PL/SQL function Cust With HighestOrder. A fragment of sample printout is given below: CUSTWITHHIGHESTORDERS 9787 Customer #000009787 i NaTSOVAPYGU261E3W24UaVE8s 14-486-611-5297 41 Deliverables Submit a file solution 2. ist (or solution2.pdf) with a report from processing of SQL script solution 2.sql. The report MUST have no errors and the report MUST list all SQL statements processed. The report MUST include ONLY SQL statements and control statements that implement the specifications of Task 1 and NO OTHER statements.