insert_telefono

create trigger trg_insert_telefono
before insert on telefono
for each row
begin
case
when :new.promocion > 0 and :new.promocion <= 10 then
:new.cantidad_sms := 30;
when :new.promocion >10 and :new.promocion <=20 then
:new.cantidad_sms :=50;
when :new.promocion >20 and :new.promocion <=30 then
:new.cantidad_sms :=100;
end case;
end;