Can someone explain how the CONTAINS function works, we are searching a CLOB that contains the text NON-XXX but when we give the following query
SELECT test FROM test_table where CONTAINS(text, '{NON-XXX}')> 0 we do not get any hits.
The table test_table hold a record that has the text NON-XXX.
The column text is of type CLOB.
Thanks