Anonymous
public sql v1 · immutable 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; 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;