ADD_SDATA_COLUMN

Use this procedure to map the FILTER BY or ORDER BY column (named in column_name) to the SDATA section (named in section_name). By default, all FILTER BY columns are mapped as SDATA.

Syntax

The syntax is as follows:

CTX_DDL.ADD_SDATA_COLUMN(
     group_name         IN VARCHAR2,
     section_name       IN VARCHAR2,
     column_name        IN VARCHAR2,
);

group_name

Name of the group that contains the section.

section_name

Name of the SDATA section.

column_name

Name of the FILTER BY column to add to the SDATA section.

Usage Notes

Mapping FILTER BY columns to sections is optional. If no section mapping exists for a FILTER BY column, then it is mapped to an SDATA section, and the section name will be the name of the FILTER BY column.
If a section group is not specified during CREATE INDEX of a composite domain index, then system default section group settings is used, and a SDATA section is created for each of the FILTER BY and ORDER BY columns.

Note: Because section name does not allow certain special characters and is case insensitive, if the column name is case sensitive or contains special characters, then an error is raised. To work around this problem, you need to map the column to an MDATA or SDATA section before creating the index.
An error will be raised if a column mapped to MDATA also appears in the ORDER BY column clause.
Column section names are unique to their section group. That is, you cannot have an MDATA column section named FOO if you already have an MDATA column section named FOO. Furthermore, you cannot have a field section named FOO if you already have an SDATA column section named FOO. This is true whether it is implicitly created (by CREATE INDEX for FILTER BY or ORDER BY clauses) or explicitly created (by CTX_DDL.ADD_SDATA_COLUMN).
One section name can only be mapped to one FILTER BY column, and vice versa. For example, mapping a section to more than one column or mapping a column to more than one section is not allowed.
Column sections can be added to any type of section group, including the NULL section group.
99 is the maximum number for SDATA sections and columns.
If the datatype of a FILTER BY or ORDER BY column is DATE, then the DATE datatype values must conform to the YYYY-MM-DD or YYYY-MM-DD HH24:MI:SS format. For example, to store a DATE value of “Nov. 24, 2006 10:32 PM 36 sec”, the document appears as <TAG>2006-11-24 22:32:36</TAG>.

Related Topics