Document Management with Oracle Text June 12, 2003 A few years
ago, many projects started using the multimedia capability of
Oracle databases. Powerful procedures for handling image, audio,
video and the text data in various formats are incorporated in
the database kernel code; even the default database installation
has multimedia objects installed. Storing, retrieving and
searching the text from documents stored inside the Oracle
database are the most common usage of multimedia database
capabilities. This feature, incorporated into the product was
formerly known as ConText, later known as interMedia Text (iMT)
and with the database version 9.X, it is known as Oracle Text.
This article covers: Document Index Type Oracle Text is an
extension to the Oracle database that allows searching specific
words in the tables of documents, using standard SQL
expressions. Oracle Text is integrated in a number of Oracle
products such as Portal, iFS and Applications. Supported
document types are text, HTML, DOC, XLS, PPT, PD