· 8 years ago · Mar 07, 2018, 06:28 PM
1CREATE OR REPLACE TRIGGER part1
2 BEFORE INSERT ON SIGHTINGS
3 REFERENCING NEW AS newTuple
4 FOR EACH ROW
5 BEGIN
6 IF EXISTS( SELECT *
7 FROM FEATURES
8 WHERE :newTuple.LOCATION = LOCATION )
9 THEN
10 INSERT INTO FEATURES VALUES(:newTuple.LOCATION,'UKNOWN',NULL,NULL,NULL,NULL);
11 DMBS_OUPUT.PUT_LINE('Warning: Insert into the SIGHTINGS table references location ' || :newTuple.LOCATION ||' that is not found in the database.');
12 END IF;
13 END part1;