Learn about querying large object data, including the full
text search capability that handles unstructured and semistructured
data.
Full Text Search
Full text search uses TEXT indexes to quickly find all instances of a term (word) in a database without having to scan table rows.
NGRAM TEXT Index Searches
Fuzzy and non-fuzzy search capability over a TEXT index is possible for TEXT indexes of type NGRAM.
Queries on LONG BINARY Columns
In WHERE clauses of the SELECT statement, you can use LONG BINARY columns only in IS NULL and IS NOT NULL expressions, in addition to the BYTE_LENGTH64, BYTE_SUBSTR64, BYTE_SUBSTR, BIT_LENGTH, OCTET_LENGTH, CHARINDEX, and LOCATE functions.
Queries on LONG VARCHAR Columns
In WHERE clauses of the SELECT statement, you can use LONG VARCHAR columns only in IS NULL and IS NOT NULL expressions, in addition to the BIT_LENGTH, CHAR_LENGTH, CHAR_LENGTH64, CHARINDEX, LOCATE, OCTET_LENGTH, PATINDEX, SUBSTRING64, and SUBSTRING functions.