1. Using a PL/SQL stored procedure and making appropriate call to the procedure. Show the Customers...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these databases questions
-
Introduction In 2010, New United Motor Manufacturing, Inc., a unique and highly successful joint venture between Americas General Motors and Japans Toyota, went out of business. NUMMI, as the...
-
can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...
-
Use Figure 17.2 to explain why cost minimization through a tangency between an isoquant and a budget line does not apply in cases where D and M are either perfect complements or perfect substitutes....
-
What are the four common GT cell configurations, as identified in the text?
-
Morrow Corporation had only one job in process during May-Job X32Z-and had no finished goods inventory on May 1. Job X was started in April and finished during May, Data concerning that job appear...
-
Steam \(\left(\mathrm{H}_{2} \mathrm{O} ight.\) vapor) flows in a pipeline in a power station. The steam pressure is \(150 \mathrm{psia}\), its temperature is \(500{ }^{\circ} \mathrm{F}\), and it...
-
During 2014, Bobs Ceramics Shop had sales revenue of $60,000, of which $25,000 was on credit. Atthe start of 2014, Accounts Receivable showed a $3,500 debit balance, and the Allowance for Doubtful...
-
You have $36,000 to Invest in Sophie Shoes, a stock selling for $60 a share. The initial margin requirement is 65 percent. calculate your rates of return if the stock rises to $90 a share and if it...
-
Please respond to the following: From the e-Activity, assess the advantages and disadvantages of the continued use of the traditional relational database and then decide if businesses should be...
-
Charles was sent some information about a bond broker but some of details were missing. The broker said they could sell him a bond that matures in 4 years for $876 ($1,000 par). He was told the bond...
-
Explore the attached pay slip of an international student and find out: CPP EI Federal Tax Provincial Tax 2558162 ONTARIO INC. 5025 Heatherleigh Avenue Mississauga. ON L5V2Y7 One Thousand One...
-
A total of $8,000 in supplies was purchased during the year. By the end of the year, the company had used up $5,300 of the supplies. The adjusting entry needed at the end of the year is ?
-
First Firm's market cap is $5,940. This includes cash of $542. The firm has 299 shares outstanding. First Firm uses its cash to pay a dividend. If a retired lady has 61 shares, and needs a total of...
-
How may share repurchases by a company be used to support the share price of that company? Explain.
-
Do you think our society is becoming more secular? Or is it more a matter of some religious organizations gaining popularity while others types lose followers? Explain.
-
7. Baladna wants to analyze process that includes delivery by suppliers, production inside the company, transportation to to its customers and information systems. Then it also wants to find out...
-
On 1 January 2023, Blue Jay Ltd revalued land from \(\$ 300000\) to \(\$ 500000\). On 1 January 2024, the company subsequently revalued the land to \(\$ 420000\). And on 1 January 2025 , the company...
-
The following data from Lyre Ltd's accounts relates to two assets at 30 June 2023. At 30 June 2023 Lyre Ltd decides to adopt the revaluation model for both these assets. On this date land has a fair...
-
Crane Ltd has proposed that the company adopt the revaluation model for fixed assets. Some of these assets are hard to obtain and certain items have increased in value in the current period, however...
Study smarter with the SolutionInn App