Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does Oracle support full text search?

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

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

like image 560
JosephStyons Avatar asked Oct 14 '08 20:10

JosephStyons


People also ask

Does Oracle support text data type?

The text data types described in Table 2-3, "OLAP DML Text Data Types" are supported by Oracle OLAP. Up to 4000 bytes for each line in the database character set. This data type is equivalent to the CHAR and VARCHAR2 data types in the database.

Does SQL Server support full text search?

Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables.


1 Answers

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.

like image 102
Justin Cave Avatar answered Oct 05 '22 02:10

Justin Cave