oracle判断字符串中包函另外一个字符串

select * from AGENT_ANNOUNCEMENT t where instr(t.range,'DOMAIN')>0;