mjfigur
asked on
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.
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?
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?
>>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.
I don't understand this question. To search only META section groups you build the SQL to make a WITHIN call.
ASKER
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.
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.
I don't understand what you mean. What 'customer HTML group'?
I assume you are looking at:
http://download.oracle.com/docs/cd/E11882_01/text.112/e16594/csection.htm#CCAPP9307
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'?
I assume you are looking at:
http://download.oracle.com/docs/cd/E11882_01/text.112/e16594/csection.htm#CCAPP9307
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'?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the link I just figured out how it is indexing these groups thanks again for your help.
Since you are storing the documents in a BLOB field, I assume they are binary. Do they have delimited sections that could be indexed?