Hi,
I have a requirement to find a text based search. I need to find records where they have a word "negative" or "not" within 5 words of "dialysis"..I am able to find the word "negative" but unable to find "not" as it is a reserved word.
Here are the create table & insert statements..
drop table ab;
create table ab(x varchar2(100));
Insert into ab values ('not on dialysis');
Insert into ab values ('negative not on dialysis');
Insert into ab values ('negative on dialysis');
Insert into ab values ('or dialysis');
create index a_idx on ab (x) indextype
is ctxsys.context
parallel 32;
Select * from ab where instr (lower(x),'dialysis') > 0
and (contains(x,'near((dialysis,negative={not}),50)') > 0);
Due to some reason it is unable to find the first record..
The output should be :
'not on dialysis'
'negative not on dialysis'
'negative on dialysis'
Thanks