1. Using a PL/SQL stored procedure and making appropriate call to the procedure. Show the Customers...

 

Transcribed Image Text:

1. Using a PL/SQL stored procedure and making appropriate call to the procedure. Show the Customers names and the number of cars they have purchased by the customer whose ID will be provided by the user at runtime. Consider: If the customer has made atleast two purchases, then print that a discount of 5% should be applied to the customer and return implicitly that total value of the car and print that value in the procedure call. If the customer has made atleast five purchases, then print that a discount of 10% should be applied to the customer and return implicitly that total value of the car and print that value in the procedure call. 2. Create a PL/SQL script that implements user defined function to print mailing labels for customers who own a given make, model and year of a car. The detail of the customer must be provided by the user at the execution of the function call. The three values must be entered by the user. Print the input parameters in the first label. Print each label on three lines with one blank line between each label. 3. SQL query. Create a copy of the table from si.serviny using Create a PL/SQL script using stored procedure that updates the laborcost for a specific servinvno, Remember that by updating the laborcost you also need to update: tax = (laborcost + partscost)*0.13. 4. Create a copy of Employees table in hr database using SQL query. Using a PL/SQL script, create a user defined function that updates the email of the Record for the employee whose input for employee id is from the user, and returns message about the email that is updated. Print the message as well. 1. Using a PL/SQL stored procedure and making appropriate call to the procedure. Show the Customers names and the number of cars they have purchased by the customer whose ID will be provided by the user at runtime. Consider: If the customer has made atleast two purchases, then print that a discount of 5% should be applied to the customer and return implicitly that total value of the car and print that value in the procedure call. If the customer has made atleast five purchases, then print that a discount of 10% should be applied to the customer and return implicitly that total value of the car and print that value in the procedure call. 2. Create a PL/SQL script that implements user defined function to print mailing labels for customers who own a given make, model and year of a car. The detail of the customer must be provided by the user at the execution of the function call. The three values must be entered by the user. Print the input parameters in the first label. Print each label on three lines with one blank line between each label. 3. SQL query. Create a copy of the table from si.serviny using Create a PL/SQL script using stored procedure that updates the laborcost for a specific servinvno, Remember that by updating the laborcost you also need to update: tax = (laborcost + partscost)*0.13. 4. Create a copy of Employees table in hr database using SQL query. Using a PL/SQL script, create a user defined function that updates the email of the Record for the employee whose input for employee id is from the user, and returns message about the email that is updated. Print the message as well.