Defining a Stored Query Expression

To define and use a stored query expression:

1. Call CTX_QUERY.STORE_SQE to store the queries for the text column. With STORE_SQE, you specify a name for the stored query expression and a query expression.

2. Use the SQE operator to call the stored query expression in a query expression. Oracle Text returns the results of the stored query expression in the same way that it returns the results of a regular query. The query is evaluated when the stored query expression is called.

   You can delete a stored query expression by using REMOVE_SQE.