Oracle Text Section Attributes

Section attributes are the attributes that can be specified at the section level rather than at the index level. Currently, the visible section attribute is supported for sections of field type.

You can set the visible section attribute for field sections using the CTX_DDL.ADD_FIELD_SECTION API directly. You can set this attribute to one of the following values:

• FALSE: This is the default value. The text in the field section is indexed separately from the rest of the document.

• TRUE: You can set this value if you want to make the text visible within a document. The text in the field section is indexed as part of the enclosing document.

The syntax is as follows:

CTX_DDL.ADD_FIELD_SECTION(
  group_name     IN    VARCHAR2,
  section_name   IN    VARCHAR2,
  tag            IN    VARCHAR2,
  visible        IN    BOOLEAN default FALSE
);

The following example enables the visible attribute for a field section:

begin
ctx_ddl.create_section_group('fieldgroup', 'BASIC_SECTION_GROUP');
ctx_ddl.add_field_section('fieldgroup', 'author', 'AUTHOR', TRUE);
end;

Alternatively, you can use the ALTER INDEX REBUILD syntax to add a new field section and enable the visible section attribute, as follows:

ALTER INDEX index_name REBUILD parameters('ADD FIELD SECTION section_name tag tag [(VISIBLE | INVISIBLE)]');

Related Topics

• Oracle Text Reference