Passing parameters for fuzzy search
mail8mzJan 17 2013 — edited Jan 18 2013Hello,
I am using Oracle 11.2 and do fuzzy search as following:
Create table tb_test(Nm varchar2(32));
create index fuzzy_idx on tb_test(Nm) indextype is ctxsys.context parameters(' Wordlist STEM_FUZZY_PREF');
select * from tb_test where contains(Nm, 'fuzzy(Wndy,,,weight)',1) >0;
The query works fine for hardcoded string 'Wndy'. I just wonder how can I use parameter to pass the match string in PLSQL?
Thanks,