Re: Oracle text : catsearch = 0 behaviour (need to mimic contains = 0)
From: dombrooks <dombrooks_at_hotmail.com>
Date: Tue, 7 Jun 2011 05:39:18 -0700 (PDT)
Message-ID: <eb9889c8-0e12-45b3-b0fb-4c690a482506_at_j25g2000vbr.googlegroups.com>
So, could you not rewrite using MINUS or a subquery wiith NOT IN or NOT EXISTS?
e.g.
select * from mytable where rowid not in (select rowid from mytable where CATSEARCH(mycolumn, 'HELLO | WORLD',NULL) > 0) ? Received on Tue Jun 07 2011 - 07:39:18 CDT
Date: Tue, 7 Jun 2011 05:39:18 -0700 (PDT)
Message-ID: <eb9889c8-0e12-45b3-b0fb-4c690a482506_at_j25g2000vbr.googlegroups.com>
So, could you not rewrite using MINUS or a subquery wiith NOT IN or NOT EXISTS?
e.g.
select * from mytable where rowid not in (select rowid from mytable where CATSEARCH(mycolumn, 'HELLO | WORLD',NULL) > 0) ? Received on Tue Jun 07 2011 - 07:39:18 CDT