Does Oracle support full text search?

oracle full-text-search oracle-text
JosephStyons picture JosephStyons · Oct 14, 2008 · Viewed 48.4k times · Source

Is there an Oracle equivalent to MS SQL's full text search service?

If so, has anyone implemented it and had good / bad experiences?

Answer

Justin Cave picture Justin Cave · Oct 14, 2008

Oracle Text is the equivalent functionality.

I've had good experiences with it. Assuming that you are maintaining the text index asynchronously, that tends to be the first source of problems, since it may be a bit between a change being made and the index getting updated, but that's normally quite reasonable during normal operation.

Related questions

How to sync and optimize an Oracle Text index?

We want to use a ctxsys.context index type for full text search. But I was quite surprised, that an index of this type is not automatically updated. We have 3 million documents with about 10k updates/inserts/deletes per day. …

Read More
How to get around 4000 characters limitation of text_query in Oracle's CONTAINS operator?

In Oracle, the full text search syntax of Contains operator is: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN NUMBER; which means the text_query can not be more than 4000 characters long or an error will occur. I repeatedly …

Read More
Searching for Text within Oracle Stored Procedures

I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for anywhere that the developers used MAX + 1 instead of the NEXTVAL on the sequence to get the next ID number. I've …

Read More