Hi everyone, I am a beginner in Oracle Text, please be kind to me .
I have built a multi_column_datastore CONTEXT index on my application. And then, I have a specific case where I want to perform a search using this index, but excluding one of the columns.
For example, the index was built on columnA, columnB, and columnC. I want to check whether my database entries contain a keyword, which exist on any columns other than column C, using the same index. Is it possible to do this? Or do I have to build another index just to perform this check?
Thank you in advance...