Oracle 支持全文搜索吗？
Oracle 是否有相当于 MS SQL 全文搜索服务的服务？
如果是这样，有人实施过它并有好的/坏的经验吗？
Is there an Oracle equivalent to MS SQL's full text search service?
If so, has anyone implemented it and had good / bad experiences?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
Oracle Text 是等效功能。
我对此有很好的经验。 假设您异步维护文本索引，这往往是问题的第一个根源，因为在进行更改和更新索引之间可能有一点时间，但这在正常操作期间通常是相当合理的。
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.
除了 Justin 所说的之外，您还可以找到有关 Oracle Text 这里。
In addition to what Justin said, you can find more information about Oracle Text here.
进一步贾斯汀所说，可以创建索引，以便在提交时更新，尽管不建议对于大量文本这样做。
它比简单的 LIKE 与 %string% 进行比较提供了更多的功能。
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%.