We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Oracle Text Web Application and META Tags

Medium Priority
405 Views
Last Modified: 2012-06-27
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?


Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

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?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

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.

Author

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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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'?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you for the link I just figured out how it is indexing these groups thanks again for your help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.