STORE_SQE

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

Syntax

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

query_name

Specify the name of the SQE 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;

Notes

SQEs support all of the Text query expression operators. SQEs also support all of the special characters and other components that can be used in a query expression, including other SQEs.

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