I am trying to create an application in apex that uses Oracle Text to search BLOB fields. I have gotten the search to work with the below contains query.
SELECT SCORE(1), website, document from docs WHERE CONTAINS(document, 'solicitation requirements', 1) > 0
order by Score(1) desc
However when reading the Oracle documentation regarding META tags they recommend querying with the "WITHIN" phrase. (example: ken WITHIN author). My question is how would this be coded for a web application. Would a user searching have to enter the "WITHIN" command? How would you go about searching META tags but the user just enters a string such as we all do with normal Google searches?