drop  TABLE myconditions  

CREATE TABLE myconditions  
(  
     conditionid INT generated always as IDENTITY PRIMARY KEY ,  
     minvalue    INT not null,  
     maxvalue    INT not null,  
     result      INT  
) 

insert into MyConditions (MinValue, MaxValue, Result) 
select 10, 20, 1 from dual union all  
select 20, 30, 2 from dual union all  
select 0, 9, 3 from dual union all  
select 31, 40, 3 from dual 

compound trigger

create or replace trigger myconditions_trg 
  for insert or update of minvalue, maxvalue 
    on myconditions 
  compound trigger 
  
  type condition_array is table of int 
    index by binary_integer; 
  conditions condition_array; 

  procedure validate_range (p_id in int) is 
    overlapping_range exception; 
    dummy char(1); 
  begin 
    begin 
      select null into dummy 
      from myconditions t1 
          , myconditions t2 
      where t1.conditionid = p_id 
      and t2.conditionid != p_id 
      and t1.minvalue != t2.minvalue 
      and ( 
           t1.minvalue between t2.minvalue and t2.maxvalue 
           or 
           t1.maxvalue between t2.minvalue and t2.maxvalue 
          ) 
      and rownum = 1; 
      raise overlapping_range; 
    exception 
      when no_data_found then 
        -- what we're hoping for, no overlaps found
        null; 
    end; 
  exception 
    when overlapping_range then 
      raise_application_error(-20000, 
        'overlapping range for id #' || p_id); 
  end validate_range; 
  
  procedure validate_ranges is 
    l_id int; 
  begin 
    l_id := conditions.first; 
    loop 
      exit when l_id is null; 
      validate_range (l_id); 
      l_id := conditions.next(l_id); 
    end loop; 
    conditions.delete; 
  exception 
    when others then 
      conditions.delete; 
      raise; 
  end validate_ranges; 
  
  BEFORE EACH ROW is 
  begin 
    -- store id to validate 
    conditions(:new.conditionid) := 1; 
  end before each row; 
  
  AFTER STATEMENT is 
  begin 
    validate_ranges; 
  end after statement; 
  
end myconditions_trg; 

insert into MyConditions (MinValue, MaxValue, Result) 
select 101, 120, 1 from dual 

insert into MyConditions (MinValue, MaxValue, Result) 
select 111, 125, 1 from dual 

select * from myconditions 

insert into MyConditions (MinValue, MaxValue, Result) 
select 41, 50, 1 from dual union all  
select 51, 60, 2 from dual union all  
select 71, 80, 3 from dual