with tn as (select 'Norwegian' n  from dual union all    
            select 'Englishman' from dual union all    
            select 'Dane' from dual union all    
            select 'German' from dual union all    
            select 'Swede' from dual            ),    
     thn as (select 1 hn  from dual  union all    
             select 2 from dual union all    
             select 3 from dual union all    
             select 4 from dual union all    
             select 5 from dual ),    
      thc as (select 'red' hc from dual union all    
              select 'green' from dual  union all    
              select 'white' from dual   union all    
              select 'yellow' from dual  union all    
              select 'blue' from dual  ),    
      tdr as (select 'tea' dr from dual union all    
              select 'milk' from dual union all    
              select 'water' from dual union all    
              select 'beer' from dual union all    
              select 'coffee' from dual),    
      ts as (select 'Rothmans' s from dual union all    
             select 'Dunhill' s from dual union all    
             select 'Marlboro' s from dual union all    
             select 'Pall Mall' s from dual union all    
             select 'Philip Morris' s from dual ),    
      tp as (select 'cat' pet from dual union all    
             select 'bird' pet from dual union all    
             select 'dog' pet from dual  union all    
             select 'horse' pet from dual  union all    
             select 'fish' pet from dual    
      ),    
tc1 as (select n,hn,hc,dr,s,pet from tn,thn,thc,tdr,ts,tp    
where    
 ((hn =  1 and n =  'Norwegian') or (hn <> 1 and n <> 'Norwegian'))    
and    
 ((hc =  'red'  and n =  'Englishman') or(hc <> 'red'  and n <> 'Englishman'))    
and   
 ((n =  'Dane' and dr =  'tea') or    (n <> 'Dane' and dr <> 'tea'))    
and    
 ((hc =  'yellow' and s =  'Dunhill') or (hc <> 'yellow' and s <> 'Dunhill'))  
and  
 ((n =  'German' and s =  'Marlboro') or  (n <> 'German' and s <> 'Marlboro'))  
and  
 ((hn =  3 and dr =  'milk' ) or  (hn <> 3 and dr <> 'milk' ))  
and  
 ((s =  'Pall Mall' and pet =  'bird') or  (s <> 'Pall Mall' and pet <> 'bird'))  
and  
 ((n =  'Swede' and pet =  'dog') or (n <> 'Swede' and pet <> 'dog'))  
and  
 ((pet =  'horse' and hc =  'blue') or (pet <> 'horse' and hc <> 'blue'))  
and  
 ((s =  'Philip Morris' and  dr =  'beer') or (s <> 'Philip Morris' and  dr <> 'beer'))  
and  
 ((hc =  'green' and dr =  'coffee') or  (hc <> 'green' and dr <> 'coffee'))
)
                                    
,ut_3 as  (select * from tc1 tc1_1 where (hc =  'green'  and not exists (select 1 from tc1 where hn = tc1_1.hn+1 and hc = 'white')) or    
                                      (hc =  'white'  and not exists (select 1 from tc1 where hn = tc1_1.hn-1 and hc = 'green'))  
           )      
,ut_5 as  (select * from tc1 tc1_1 where (s =  'Rothmans' and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and pet =  'cat' )) or    
                                      (pet  = 'cat'    and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and s =  'Rothmans' ))  
         )  
,ut_9 as  (select * from tc1 tc1_1 where (s =  'Rothmans' and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and dr =  'water' )) or   
                                      (dr =  'water'   and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and s =  'Rothmans'  )) 
        )  
,ut_12 as (select * from tc1 tc1_1 where (n =  'Norwegian' and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and hc =  'blue' )) or  
                                      (hc =  'blue'  and not exists (select 1 from tc1 where abs(hn-tc1_1.hn) = 1 and  n =  'Norwegian' ))   
        )  
,tc2 as (  
select * from tc1 
minus 
select * from ut_3  
minus  
select * from ut_5  
minus  
select * from ut_9  
minus  
select * from ut_12) 
select * from tc2;

with ids as (select level id from dual connect by level <= 5),
i as (
select i1.id a, i2.id b, i3.id c, i4.id d, i5.id e
from ids i1, ids i2, ids i3, ids i4, ids i5
where i1.id <> i2.id and i1.id <> i3.id and i1.id <> i4.id and i1.id <> i5.id 
  and i2.id <> i3.id and i2.id <> i4.id and i2.id <> i5.id 
  and i3.id <> i4.id and i3.id <> i5.id 
  and i4.id <> i5.id),

nac as (select a angl, b dat, c sved, d nor, e nemec from i),
color as (select a red, b green, c yellow, d blue, e white from i),
anim as (select a dog, b cat, c kon, d bird, e RIBA from i),
drink as (select a water, b beer, c milk, d cofe, e tea from i),
cigar as (select a Bluemaster, b Dunhill, c Blend, d PM, e Prince from i)

select * from nac, color, anim, drink, cigar
where angl = red and sved = dog
  and dat = tea and green = white - 1
  and green = cofe and PM = bird
  and yellow = Dunhill and milk = 3
  and nor = 1 and abs(Blend-cat) = 1
  and abs(kon - Dunhill) = 1 and beer = Bluemaster
  and nemec = Prince and abs(nor-blue)=1
  and abs(Blend-water)=1;