View the step-by-step solution to:

Question

Write PL/SQL scripts to answer the following questions:


1.

Use S8.Customer for creating

copy of Customer table. Creating script that uses

cursor to print information for customers who own a given make, model and year of a

car. The three values must be entered by the user.


2.

Creating stored procedure which accepts a customer name as an argument and

displays the total amount the customer has spent buying cars. Use car database.


3.

Writing PL/SQL script that uses a trigger that converts to upper case of the

customer name, city, street and Province for Customer table during INSERT OR

UPDATE. It should mention data in a log file (Creating log table).


4.

Write PL/SQL script for Creating function to return the total number of options

on a car given the serial number of the car. Include both base options and invoice options.

Use car database

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question