CREATE OR REPLACE TRIGGER track_delete_trigger BEFORE DELETE ON ic03jc.album FOR EACH ROW DECLARE oldalbumid NUMBER :old.dbalbumid; BEGIN DELETE FROM ic03jc.album_track WHERE dbalbumid = oldalbumid; END;