Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Full text search
Hi all
In our product we have to support long text fields so we use
columns defined as VARCHAR2 (2000)
It seems to do the job but we are looking for a way to enable full
text search.
Running statements like:
'SELECT text_value FROM client_note WHERE text_value LIKE
'%SPEED%'
would be very slow and always require full table scan. Is there a
better way of doing it, especially in the Oracle 8i world?
Thanks
Witold
![]() |
![]() |