Oracle Text Web Application and META Tags

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

Open in new window

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?

Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
If you could provide some sample data and expected results it would help me a lot.

Then I can build some working models for you.
slightwv (䄆 Netminder) Commented:
WITHIN searches for entries in specific SECTIONS of a document.  If the documents have specific sections you wish to search then they can be useful.

Since you are storing the documents in a BLOB field, I assume they are binary.  Do they have delimited sections that could be indexed?
slightwv (䄆 Netminder) Commented:
>>How would you go about searching META tags but the user just enters a string such as we all do with normal Google searches?

I don't understand this question.  To search only META section groups you build the SQL to make a WITHIN call.
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

mjfigurAuthor Commented:
I thought there was going to be a mix of documents in the BLOC's, however they are all HTML documents and I was going to create HTML section and also use <META> tags.

The part that I was confused on was that if I just have a text box on a website and the user enters the word "solicit customer" what would the SQL look like to know to search in the customer HTML group? Oracle documentation states that you would use 'solicit WITHIN customer', however I cannot expect a user to use the WITHIN indicator.
slightwv (䄆 Netminder) Commented:
I don't understand what you mean.  What 'customer HTML group'?

I assume you are looking at:

Are you planning on creating a 'customer' section in the HTML group for specific HTML tags?

What other groups are you planning on creating?

How are you thinking 'solicit customer' will automatically turn into 'search this in the customer section'?
mjfigurAuthor Commented:
Thank you for the link I just figured out how it is indexing these groups thanks again for your help.
All Courses

From novice to tech pro — start learning today.