Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Meaning and when to use the ABOUT operator?

LaurySep 22 2017 — edited Oct 19 2017

Hi,

With Oracle Text, the definition of the ABOUT operator:

"Use the ABOUT operator in English or French to query on a concept. The query string is usually a concept or theme that represents the idea to be searched on. Oracle Text returns the documents that contain the theme."

The two queries below return the same result (doc column is BLOB):

select

    score(1) score,

    id,

    name

from  

    my_docs

where 

    contains(doc, 'RMAN', 1) > 0

order by

    score(1) desc;

select

    score(1) score,

    id,

    name

from  

    my_docs

where 

    contains(doc, 'about(RMAN)', 1) > 0

order by

    score(1) desc;

Can someone explain me what is the use aof ABOUT? and what means "to query on a concept"?

Kind Regards

This post has been answered by Barbara Boehmer on Oct 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2017
Added on Sep 22 2017
25 comments
843 views