Putting your text to work with Oracle Text


Oracle Text uses standard SQL to index, search, and analyze text and documents stored in the Oracle database, in files, and on the web. Oracle Text supports multiple languages and uses advanced relevance-ranking technology to improve search quality.

Test Drive Oracle Database 19c in the Cloud

Overview of Oracle Text


Oracle Text uses standard SQL to index, search, and analyze text and documents stored in the Oracle database, in files, and on the web. Oracle Text can perform linguistic analysis on documents, as well as search text using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching, mixed thematic queries, HTML/XML section searching, and so on.

It can render search results in various formats including unformatted text, HTML with term highlighting, and original document format. Oracle Text supports multiple languages and uses advanced relevance-ranking technology to improve search quality.

Oracle Text also offers advanced features like classification, clustering, and support for information visualization metaphors.

Ready to start using Oracle Text?

If you're already using the Oracle Database, enabling text searching within your applications is quite straightforward. Oracle Text uses the same SQL language as the database, and integrates seamlessly with your existing SQL. Oracle Text can be used from any programming language which has a SQL interface, meaning just about all of them.

Is your database ready to upgrade?

Visit My Oracle Support and download the pre-upgrade utility.

注:为免疑义,本网页所用以下术语专指以下含义:

  1. 除Oracle隐私政策外,本网站中提及的“Oracle”专指Oracle境外公司而非甲骨文中国。
  2. 相关Cloud或云术语均指代Oracle境外公司提供的云技术或其解决方案。