Oracle 是否支持全文搜索？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/202623/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Does Oracle support full text search?
提问by JosephStyons
Is there an Oracle equivalent to MS SQL's full text search service?
是否有相当于 MS SQL 的全文搜索服务的 Oracle？
If so, has anyone implemented it and had good / bad experiences?
如果是这样，有没有人实施它并有好的/坏的经历？
回答by Justin Cave
Oracle Textis the equivalent functionality.
Oracle Text是等效的功能。
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.
我有过很好的经验。假设您正在异步维护文本索引，这往往是问题的第一个来源，因为在进行更改和更新索引之间可能会有一点时间，但这在正常操作期间通常是非常合理的。
回答by Eddie Awad
回答by chris
And further to what Justin said, it is possible to create the index so it updates on commit, although this is not recommended for large amounts of text.
更进一步，贾斯汀说，可以创建索引，以便在提交时更新，尽管对于大量文本不建议这样做。
It offers much more power than a simple LIKE compare against %string%.
它比简单的 LIKE 与 %string% 的比较提供了更多的功能。
