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)