Oracle Database Discussions

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!

Oracle full text, the syntax of CONTAINS()

MorvenOct 30 2012 — edited Oct 31 2012

Hi guys,

contains(columnname, 'ABC')=0

this means search for the data which doesn't contain word 'ABC'

contains(columnname, 'ABC and XYZ')=0
contains(columnname, 'ABC or XYZ')=0

what do these 2 sql mean? I tested them, there's no syntax error, but they didn't work as I expected, the 'and' seems like an 'or', and 'or' seems like an 'and', could anyone help to explain this? all doc found in google are for contains()>0, those're not what I need.

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2012

Added on Oct 30 2012

#general-database-discussions

4 comments

173 views