Question: PL/SQL What doeas the following code do ? CREATE OR REPLACE TRIGGER T AFTER DELETE BEGIN INSERT INTO orders_a ( order_id, quantity, cost_per_item, total_cost, delete_date,

PL/SQL

What doeas the following code do ? CREATE OR REPLACE TRIGGER T AFTER DELETE BEGIN INSERT INTO orders_a ( order_id, quantity, cost_per_item, total_cost, delete_date, deleted_by) VALUES (:old.order_id, :old.quantity, :old.cost_per_item, :old.total_cost, sysdate, user ); END

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!

What does the following code do? CREATE OR REPLACE TRIGGER T AFTER DELETE BEGIN INSERT INTO orders_a ( order_id, quantity, cost_per_item, total_cost, delete_date, deleted_by) VALUES ( :old.order_id,...

CCIT 4 2 6 : Database - 2 Lab 6 : Exception Handling and Triggers LAB 6 Content PL / SQL - Records In this chapter, we will discuss Records in PL / SQL . A record is a data structure that can hold...

Please write a PLSQL code for the following SQL PLSQL Question Please Use the following code and provide both SQL and PLSQL Statements Code 1(Step 1) https://codeshare.io/2EMK1o Code 2 (Step 2)...

ASSIGNMENT #2 SECTION A Using Scalar Variables Create a PL/SQL block containing the following variables : NAME DATA TYPE OPTION INITIAL VALUE lv_test_date DATE December 10, 2012 lv_test_num NUMBER...

CREATE TABLE " ACTOR " ( "ID" NUMBER(9,0) NOT NULL, "NAME" VARCHAR2(100) NOT NULL, CONSTRAINT ACTOR_PK PRIMARY KEY (ID)); CREATE TABLE " MOVIE " ( "ID" NUMBER(9,0) NOT NULL, "TITLE" VARCHAR2(100) NOT...

Using the following relations: Patients(pid, name, address, telephone, care_centre_id) Care_centres(cid, name, location, nurse_charge_id) Treatments(tid, patient_id, physician_id, treatment_name,...

Write a PL/SQL block with the following specifics: Create a variable that will be used to contain a salary amount. Make it a constant with an intital value of 10000. Try several values for this...

Write a PL/SQL block to the following questions. I have attached the ERD to help with the problems. Thank you. Tell me what you want to do Insert Draw Design Layout References Mailings Review View Be...

PL/SQL What does the following code do ? Replace the error messages "error1" and "error2" with more meaningful messages. CREATE OR REPLACE PROCEDURE add_new_supplier (supplier_id_in IN NUMBER,...

Use a cursor in PL/SQL to generate the following *: Invoice Overdue! Invoice Number: 113 Invoice due date: 20-JUL-14 Amount Due: $21842 Invoice Overdue! Invoice Number: 114 Invoice due date:...

A corporation has two departments that produce two separate product lines. The company has been implementing total quality management over the past year. Revenue and costs of quality for that year...

The adjusting entry to record interest earned but not yet collected 1. increase liabilities and decease stockholders' equity 2. increase assets and increase stockholders' equity 3. increase...

The value of a derivatives contract is most likely to be directly affected by the: A price of the underlying. Demand for the underlying asset Supply of the underlying asset. None of the above.

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Ethics.Teamwork. A manager of a department store tries to follow a company policy that prohibits off-the-clock work requirements of employees;however, store managers have to keep payroll costs below...

Search the Internet to learn about the International Association of Virtual Assistants. Answer the following questions: a. How large is the groups membership? b. What are the dues? c. What are the...

Locate an example of a contract. Describe the four essential elements applicable to this contract. a. Offer and acceptance b. Competency of parties c. Legality of subject matter d. Consideration