This is a utility provided by Oracle to enable the reading of data from binary documents such as Word, into an Oracle database. Article Text is a text manipulation tool containing several functions and applications to query and classify documents based on text based data. It includes Word search and indexing as well as viewing functions for text.
Oracle Text is not just about manipulating text, as it can also classify documents with its documents classification application included. The text search function allows users to search for text using several search terms if so desired. Text is usually contained within a number of documents, as opposed to a single document. This makes searching capability more flexible as it can search several documents in a single instance. Oracle Text can also search through several different types of documents such as plain format, HTML, Microsoft Word or XML. This means that websites and other types of documents that are not purely in plain text are searchable.
The search functionality includes a document classification application in that it can classify documents as well as search information within those documents. The documentation classification application works based on the content type, such as sport or the latest news. This is regardless of the format the data is in, such as HTML, or XML. The idea is that certain types of categories are indexable for classifying and searching. Now, however, Oracle Text long support classifications for plain text, HTML and XML. The document classification function also works in different languages, such as French. Related words help to classify documents even if such a word does not exist in the document. For example, support could return classifications of football, tennis and Ruby. This is possible even though the word "sport" may not actually exist in these documents.
The advantage of using Oracle Text for populating an Oracle database table with the data is that the functions contained within the utility write directly to Oracle tables. However, it is not easy to use for the novice Oracle user, and study of the Oracle documentation is important.