Write PL/SQL scripts to answer the following questions:
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.
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.
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).
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