title: Counting the number of hits for a given search query/term per document in Oracle
body: <p>I have a table containing blobs of document text that I am joining to. Using oracle text, i can get the snippet of text containing my search term (using ctx_doc.snippet). However, I must now specify the number of times this search term was found for each document that matched my join not all documents that i have. I have over 100K documents total but joins i do and filtering return a subset.</p>
  
  <p>Reading online, there's CTX_QUERY.COUNT_HITS that i can use but that gives the count for all documents. If I had a textkey paraemeter for COUNT_HITS, life would be good but none exists.</p>
  
  <p>How can i go about accomplishing the number of hits for a given query in a document in Oracle?</p>