Question: Write 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

Write 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 write all data in a log file (create a log table). 4. Write PL/SQL script to create a 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In the figure here, the battery has 12.0 V, and the lightbulbs are all identical. The circuit puts the most of light out when A B 0 E all the switches are closed. switches B, D, and E are closed, and...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

please answer it with a screenshot CREATE TABLE Product143( productNO char(10), label varchar(30), price decimal(9,2), QStock INTEGER(11), PRIMARY KEY(productNO) ); INSERT INTO Product Values...

Good evening need some Oracle/SQL help please 1. Use the CUSTOMERS table Display the number of months between the order _date for the customer with customer _ id of 8 and todays date. Round to the...

Use MICROSOFT SQL SERVER language to fill the block like (...) Here is the diagram 1)Create a trigger that can update the ItemNum field automatically The trigger should be create on InvoiceItemeven...

answer the question which is in the paper and add two cursor after question 4 with a screenshot please CREATE TABLE Product143( productNO char(10), label varchar(30), price decimal(9,2), QStock...

CREATE TABLE REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), PROVINCE CHAR(3), ZIP CHAR(5), COMMISSION DECIMAL(7,2), RATE DECIMAL(3,2) );...

Which best describes the benefits of cross-decking in distribution management?

4. Using the information below for Mrs. T's Pizza Shop, (a) prepare a bank reconciliation as of October 31, 2019 and (b) record the necessary correction journal entries. Bank Statement balance at the...

Which data mining process / methodology is thought to be the most comprehensive? Select one. A kDD Process B proprieury organizational methodoligen c . SEMUA D . CHISP.DUS

Suppose that 0.010 0 M Mn 2+ is titrated with 0.005 00 M EDTA at pH 7.00. (a) What is the concentration of free Mn 2+ at the equivalence point? (b) What is the quotient [H 3 Y - ]/[H 2 Y 2- ] in the...

You are required to carry out a research on the subject matter given below and write an essay. At the beginning of 2021, the Senior Management of Chemicals Makers Fiji Ltd. (CMFL), a manufacturer of...

Cumene (C 6 H 5 C 3 H 7 ) is produced by reacting benzene with propylene [H r (77F) = -39;520 Btu]. A liquid feed containing 75 mole% propylene and 25% n-butane and a second liquid stream containing...

Education is an area in which it has been hard to create productivity gains that reduce costs. Collect data on the tuition rates of your own college in the last 20 years and compare that increase to...

Are capital controls effective in practice? Explain.

Ben is a new hire who was recently added to the project team in charge of implementing the new HRIS application. He is based in Australia, whereas the rest of the team are in Singapore. As the...

What arguments does the SLN function take?

The Wine Depot owned the following fixed assets as of December 31, 2018: You are to create Wine Depots fixed asset depreciation summary and individual depreciation worksheets using the straight-line...

What SUP Partial Year Sum of the Years Digits Depreciation for Asset 1004 Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated...

Dunn et al. (1999) also classified the phase II sample by gender. In the following table, the entries in columns 37 are the counts from the phase II sample in the categories: Male Non-Case (MNC),...

Optimal allocation for two-phase sampling with stratification. Suppose phase I is an SRS and phase II is a stratified random sample, and that the total cost for the sample is given in (12.15), where...

Bart and Earnst (2002) describe the use of two-phase sampling with ratio estimation to estimate the density of nesting birds. The phase I sample, selected from the 2130 plots in the region of...