5 Replies Latest reply: Jan 18, 2013 9:11 AM by 942572 RSS

    Passing parameters for fuzzy search


      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?