Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Best way to search a large VARCHAR2 column
I would use the INSTR built in function. You can look it up in the documentation.
Colin.
Suwat Phruksawan wrote in message <6ffm47$6rg_at_argentina.earthlink.net>...
>What is the best way to do a search for keywords on a large (up to 2000)
>VARCHAR2 column. Basically, I tried to avoid sequential search, one record
>at a time. And make the index on that particular column seems expensive.
>
>Any help is appreciated.
>Thanks,
>Suwat.
>
>
Received on Sun Mar 29 1998 - 00:00:00 CST