select * from T_tableName t
Where (t.texta like '%xx%' Or t.texta Like '%oo%' or
t.textb like '%xx%' or t.textb like '%oo%')
order by
(Case When Instr(texta||textb,'xx')>0 Then 1 Else 0 End)+
(case when instr(texta||textb,'oo')>0 then 1 else 0 end) desc
Where (t.texta like '%xx%' Or t.texta Like '%oo%' or
t.textb like '%xx%' or t.textb like '%oo%')
order by
(Case When Instr(texta||textb,'xx')>0 Then 1 Else 0 End)+
(case when instr(texta||textb,'oo')>0 then 1 else 0 end) desc