Intermedia Query Question

From: Ronnie <ronnie_yours_at_yahoo.com>
Date: 15 Jul 2004 08:20:06 -0700
Message-ID: <ea603f8d.0407150720.a30896c@posting.google.com>

Hi,

I have a table such that

SQL> desc testtable
Name Type Nullable Default Comments ----- ------------ -------- ------- -------- DUMMY VARCHAR2(50) Y SQL> select * from testtable
  2 /

DUMMY

---

tom
trisha
nancy
tom trisha
nancy trisha
nancy tom
tom nancy
tom nancy trisha
trisha tom nancy

I create an intermedia textindex on the table using the command

create index testindex on testtable(dummy) indextype is ctxsys.context;

Now when i issue a query such as

SQL> select * from testtable where contains (dummy,'anurag trisha')>0;

DUMMY

---

tom trisha

It matches the whole string. The results I am expecting is

DUMMY

---

tom trisha
tom nancy trisha
trisha tom nancy

That is in the beginning it should list the records wherever tom trisha exist next to each other and later at the end it should bring all the records where both tom and trisha exist even though they are not next to each other.

Please suggest.

Thanks
Ron Received on Thu Jul 15 2004 - 10:20:06 CDT