Oracle Text Web Application and META Tags

Posted on 2011-04-21
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?

Question by:mjfigur
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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?
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>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 Comment

    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.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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'?
    LVL 76

    Accepted Solution

    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.

    Author Closing Comment

    Thank you for the link I just figured out how it is indexing these groups thanks again for your help.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
    The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now