SQL database

Question

Create a trigger named Products_INSERT that sets DateAdded column of the Products table to current date if the value for that column is null. Test this trigger with the following INSERT INTO Products (CategoryID, ProductCode, ProductName, Description, ListPrice, DiscountPercent) VALUES (1, 'G5122', 'Gretsch G5122 Double Cutaway Hollowbody', '', 999.99, 32); Check and make sure the date was inserted with a SELECT statement.

Answer 1

CREATE OR REPLACE TRIGGER Products_INSERT ON PRODUCTS

BEFORE INSERT

ON PRODUCTS

FOR EACH ROW

BEGIN

IF INSERTING AND :NEW.DateAdded IS NULL THEN

:NEW.DateAdded := sysdate;

END IF;

END;

SELECT * FROM PRODUCTS WHERE CategoryID = 1;