This page shows how Oracle Text can be used within an Interactive Grid to perform full-text search using linguistic features. An Oracle Text index has been created on your table. Consult the Oracle Text Application Developers Guide for details. For performance reasons, only one Oracle Text index may be used within an Interactive Grid. In Page Designer, navigate to the Attribute Section, then to Oracle Text Index Column and select the table column, for which the Oracle Text index has been created.

In this example, Oracle Text features are available to search the Name and Country columns with the Interactive Grid Row Filter. Type your query (or one of the below examples) into the Search: Full text field. Your query is automatically translated to Oracle Text query syntax by the EBA_DEMO_IG_TEXT_PKG.CONVERT_TEXT_QUERY function. It will find exact as well as fuzzy matches.

Query Examples (fuzzy logic will find results)

• Julius Caesar
• gustav eifel
• armstong states

You can also type in Oracle Text query syntax directly; simply prefix your query with ORATEXT:. For details about the query syntax, consult the Oracle Text Application Developers' Guide.

• ORATEXT: Julius and ?Itali
• ORATEXT: Einstein and Germany