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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Big problem with Oracle Text

AS84Feb 21 2011 — edited Feb 24 2011
Hi all,
I'm using Oracle text to execute a full text search. I indexed my column like that

CREATE INDEX cm_property_text ON cm_property(text_value) INDEXTYPES IS CTXSYS.CONTEXT

After that, I inserted into the field text_value one line have contain is: "I and you or other" and then execute the command to synchronous my Index:

Begin
CTXSYS.CTX_DLL.SYNC_INDEX('cm_property_text');
end;

Then I execute the Query to select out the row have text_value contains text value is "I and you"

SELECT * FROM cm_property WHERE CONTAINS(text_value,'I /and you')

But I didn't receive anything. And I tried change to the text input search like that

SELECT * FROM cm_property WHERE CONTAINS(text_value,'I /and you /or other');

And I had one row which is the row I inserted before.

I really don't why? Who can help me to explain about it?

Thank you so much!
This post has been answered by Barbara Boehmer on Feb 22 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2011
Added on Feb 21 2011
6 comments
6,159 views