Create a trigger that checks if “value” is greater than 1000 for any new row inserted to “Test” table, then insert a row to Audit table?
Create a trigger that checks if “value” is greater than 1000 for any new row inserted to “Test” table, then insert a row to Audit table?
Share
INSERT INTO Test_audit
VALUES(:NEW.test_id, :NEW.value, :NEW.test_date);
END trg_test;
. . . . . . . . . . . . .
SUPPORT US !
VOTE UP ANSWER !
ANSWER IS IN THE ATTACHMENT JUST TAP ON IT: