Stored Query: General

Name: Name of the Oracle interMedia Text stored query. In the generated statement (displayed if you click the Show SQL button), this value is used for the query_name parameter in the CTX_QUERY.STORE_SQE procedure call.

Schema: Schema that owns the stored query.

Query Text: SQL statement that performs the query. In the generated statement (displayed if you click the Show SQL button), this value is used for the text_query parameter in the CTX_QUERY.STORE_SQE procedure call.

Example: If Name is DISASTER and Query Text is hurricane | earthquake, the generated SQL statement is:

BEGIN ctx_query.store_sqe('CTXSYS.DISASTER', 'hurricane | earthquake'); END;

This stored query expression (SQE) returns all documents that contain either hurricane or earthquake. The SQE can then be called within a query expression, such as the following:

select score(1), docid from emp

where contains(resume, 'sqe(disaster)', 1)> 0

order by score(1);

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)