Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table T1( id primary key ) 
as
select 1 from dual union all
select 2 from dual union all    
select 3 from dual ;
3 rows affected

create table T2 ( id, value1_id, value2_id )
as
select 1, '01', 2 from dual union all
select 1, '02', 3 from dual union all
select 1, '03', 1 from dual union all
select 2, '04', 2 from dual union all
select 2, '05', 2 from dual union all
select 2, '02', 3 from dual union all
select 2, '06', 4 from dual union all
select 2, '07', null  from dual union all
select 3, '08', 2 from dual union all
select 3, '02', 3 from dual union all
select 4, '09', 2 from dual union all
select 4, '10', 1 from dual ;
12 rows affected

select t2.*, 'T1 id not valid' as status
from t2
where t2.id not in ( select id from T1 )
union all
select t2.*, 'value1_id <-> value2_id mapping incorrect '
from t1 join t2 on t1.id = t2.id
where
    ( t2.value1_id in ('01','04','05','08','09') and t2.value2_id <> 2 )
    or
    ( t2.value1_id = '02' and t2.value2_id <> 3 )
    or
    ( t2.value1_id in ('03','10') and t2.value2_id <> 1 )
    or
    ( t2.value1_id = '06' and t2.value2_id <> 4 )
    or
    ( t2.value1_id = '07' and t2.value2_id is null )
;


ID
VALUE1_ID
VALUE2_ID
STATUS


4
09
2
T1 id not valid

4
10
1
T1 id not valid

2
07
null
value1_id <-> value2_id mapping incorrect

ID	VALUE1_ID	VALUE2_ID	STATUS
4	09	2	T1 id not valid
4	10	1	T1 id not valid
2	07	null	value1_id <-> value2_id mapping incorrect