Defined Stored Query Expressions

Use the CTX_QUERY.STORE_SQE procedure to store the definition of a query without storing any results.

Referencing the query with the CONTAINS SQL operator references the definition of the query. In this way, you can use the stored query expressions to define long or frequently used query expressions.

Stored query expressions are not attached to an index. When you call CTX_QUERY.STORE_SQE, you specify only the name of the stored query expression and the query expression.

The query definitions are stored in the Text data dictionary. Any user can reference a stored query expression.

Related Topics

• Defining a Stored Query Expression

• SQE Example

• Oracle Text Reference