With Oracle Text, you can create a CONTEXT index with columns of type VARCHAR2, CLOB, BLOB, CHAR, BFILE, XMLType, and URIType.
CONTEXT
VARCHAR2
CLOB
BLOB
CHAR
BFILE
XMLType
URIType
Note:
The column types NCLOB, DATE and NUMBER cannot be indexed.
NCLOB
DATE
NUMBER
Scripting on this page enhances content navigation, but does not change the content in any way.