Skip to content
Advertisement

Tag: oracle10g

How does contains() in PL-SQL work?

Have a lot of unnecessary results using contains() method in my query. Don’t tell me to use like or something else. It is hardcoded and couldn’t be changed. Answer Contains is used on text fields that have a ‘CONTEXT Index’, which indexes a text field for searching. The standard usage is like this (using the score operator to display what

Advertisement