Re: Oracle Text Index

Todd,

thanks for your help ! I tried this out and it worked ! Nice Oracle feature :-)

Peter

> Peter:
>
> From the docs:
>
> =====
> To index, you must create a dummy column to specify in the CREATE
> INDEX statement. This column’s contents are not made part of the
> virtual document, unless its name is specified in the columns
> attribute.
> The index is synchronized only when the dummy column is updated. You
> can create triggers to propagate changes if needed.
> =====
>
> So, if your MCD preference specified columns a, b, and c, and the
> index was built on column a, then you need a trigger that "fakes" an
> update to column a based on a change in columns b or c. Something
> like:
>
>
Received on Mon Nov 24 2003 - 03:12:32 CST