STORE_SQE

This procedure creates a stored query expression. Only the query definition is stored.

Supported Operators

Stored query expressions support all of the CONTAINS query operators. Stored query expressions also support all of the special characters and other components that can be used in a query expression, including other stored query expressions.

Privileges

Users are allowed to create and remove stored query expressions owned by them. Users are allowed to use stored query expressions owned by anyone. The CTXSYS user can create or remove stored query expressions for any user.

Syntax

CTX_QUERY.STORE_SQE(query_name      IN VARCHAR2,
                    text_query      IN VARCHAR2);

query_name

Specify the name of the stored query expression to be created. If you are CTXSYS, you can specify this as user.name.

text_query

Specify the query expression to be associated with query_name.

Examples

begin
ctx_query.store_sqe('disasters', 'hurricanes | earthquakes');
end;