create or replace trigger SMS_WORKFLOW
AFTER INSERT OR DELETE ON t_station_info
for each row
declare
-- local variables here
begin
IF INSERTING THEN
INSERT INTO t_station_sim(stationcode) VALUES(:NEW.stationcode);
ELSIF DELETING THEN
DELETE FROM t_station_sim WHERE stationcode=:OLD.stationcode;
END IF;
end SMS_WORKFLOW;