17 Object Types

The Expression Filter feature supplies a set of predefined types and public synonyms for these types. Most of these types are used for configuring index parameters with the Expression Filter procedural APIs. Use the EXF$TABLE_ALIAS type to support expressions defined on one or more database tables. Table 17-1 describes the Expression Filter object types.

None of the values and names passed to the types defined in this chapter are case sensitive. To preserve the case, enclose the values with double quotation marks.

Tip:

See the chapter describing the Expression Filter Object Types in Oracle Database PL/SQL Packages and Types Reference for all reference information concerning Expression Filter object types. Use the links in the Object Type Name column in Table 17-1 to see each object type.

Table 17-1 Expression Filter Object Types

Object Type Name	Description
EXF$ATTRIBUTE	Specifies the stored and indexed attributes for the Expression Filter indexes
EXF$ATTRIBUTE_LIST	Specifies a list of stored and indexed attributes when configuring index parameters
EXF$INDEXOPER	Specifies a list of common operators in predicates with a stored or an indexed attribute
EXF$TABLE_ALIAS	Indicates a special form of elementary attribute used to manage expressions defined on one or more database tables
EXF$TEXT	Associates preferences to a text attribute in an attribute set or an event structure.
EXF$XPATH_TAG	Configures an XML element or an XML attribute for indexing a set of XPath predicates
EXF$XPATH_TAGS	Specifies a list of XML tags when configuring the Expression Filter index parameters