I have a table which has 20 similar text attribute columns, text1..text20. These columns are of type CLOB. I am looking to find rows where one of these text attribute columns contain a specific phrase, such as ‘%unemployed%’. I need to know 2 things, which rows match, and which column was matched on. I thought I could use ANY as
Tag: contains
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