This discussion is archived
5 Replies Latest reply: Jan 18, 2013 7:11 AM by 942572 RSS

Passing parameters for fuzzy search

942572 Newbie
Currently Being Moderated
Hello,

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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points