Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Using a PL / SQL stored procedure and making appropriate call to the procedure. Show the Customers names and the number of cars
Using a PLSQL 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 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 should be applied to the customer and return implicitly that total value of the car and print that value in the procedure call.
Create a PLSQL 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.
Create a copy of the table from siservinv using SQL query.
Create a PLSQL 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
Create a copy of Employees table in hr database using SQL query.
Using a PLSQL 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started