MULTI_COLUMN_DATASTORE Attributes

The data store MULTI_COLUMN_DATASTORE has the attributes shown in Table 2-2.

Table 2 MULTI_COLUMN_DATASTORE Attributes

Attribute Attribute Value

columns

Attribute	Attribute Value
columns	Specify a comma-delimited list of columns to be concatenated during indexing. You can also specify any allowed expression for the `SELECT` statement column list for the base table. This includes expressions, PL/SQL functions, column aliases, and so on. The `NUMBER` and `DATE` column types are supported. They are converted to text before indexing using the default format mask. The `TO_CHAR` function can be used in the column list for formatting. The `RAW` and `BLOB` columns are directly concatenated as binary data. The `LONG`, `LONG` `RAW`, `NCHAR`, and `NCLOB` data types, nested table columns, and collections are not supported. The column list is limited to 500 bytes.
filter	Specify a comma-delimited list of Y/N flags. Each flag corresponds to a column in the `COLUMNS` list and denotes whether to filter the column using the `AUTO_FILTER`. Specify one of the following allowed values: Y: Column is to be filtered with `AUTO_FILTER` N or no value: Column is not to be filtered (default)
delimiter	Specify the delimiter that separates column text as follows: `COLUMN_NAME_TAG`: Column text is set off by XML-like open and close tags (default). `NEWLINE`: Column text is separated with a newline.

Specify a comma-delimited list of columns to be concatenated during indexing. You can also specify any allowed expression for the SELECT statement column list for the base table. This includes expressions, PL/SQL functions, column aliases, and so on.

The NUMBER and DATE column types are supported. They are converted to text before indexing using the default format mask. The TO_CHAR function can be used in the column list for formatting.

The RAW and BLOB columns are directly concatenated as binary data.

The LONG, LONG RAW, NCHAR, and NCLOB data types, nested table columns, and collections are not supported.

The column list is limited to 500 bytes.

filter

Specify a comma-delimited list of Y/N flags. Each flag corresponds to a column in the COLUMNS list and denotes whether to filter the column using the AUTO_FILTER.

Specify one of the following allowed values:

Y: Column is to be filtered with AUTO_FILTER

N or no value: Column is not to be filtered (default)

delimiter

Specify the delimiter that separates column text as follows:

COLUMN_NAME_TAG: Column text is set off by XML-like open and close tags (default).

NEWLINE: Column text is separated with a newline.