Question: 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
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,
: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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
