Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing parameters for fuzzy search

mail8mzJan 17 2013 — edited Jan 18 2013
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,
This post has been answered by stefan nebesnak on Jan 17 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2013
Added on Jan 17 2013
5 comments
418 views