Sources |
http://docs.oracle.com/cd/E11882_01/text.112/e24436/cqspcl.htm#i1006256 |
||
Reserved Word |
Reserved Character |
Operator |
Expanded Information |
ABOUT |
(none) |
ABOUT |
to search for documents that are about soccer: 'about(soccer)' |
ACCUM |
, |
Accumulate |
to search for at least one occurrence of the query terms with assigned weights for relevancy |
AND |
& |
And |
to search for at least one occurrence of each of the query terms |
BT |
(none) |
Broader Term |
to expand a query to include the term defined in the thesaurus as a broader term for term |
BTG |
(none) |
Broader Term Generic |
to expand a query to include all terms defined in the thesaurus as broader generic terms for term |
BTI |
(none) |
Broader Term Instance |
to expand a query to include all the terms defined in the thesaurus as broader instance terms for term |
BTP |
(none) |
Broader Term Partitive |
to expand a query to include all the terms defined in the thesaurus as broader partitive terms for term |
EQUIV |
= |
Equivalence |
to specify an acceptable substitution for a word in a query |
FUZZY |
? |
fuzzy |
to expand queries to include words that are spelled similarly to the specified term |
(none) |
{} |
escape characters (multiple) |
to escape a string of characters or symbols such that everything inside a set of braces is part of the escape sequence; escaping a single character causes the escaped character to become a separate token in the query; use }} to include the close brace in the expression |
(none) |
\ |
escape character single |
to escape a single character or symbol such that only the character immediately following the backslash is escaped; use \\ to indicate the backslash character |
(none) |
() |
grouping characters |
to group terms and operators found between the characters |
(none) |
[] |
grouping characters |
to group terms and operators found between the characters but to prevent penetrations for the expansion operators (fuzzy, soundex, and stem) |
HASPATH |
(none) |
HASPATH |
to find all XML documents that contain a specified section path; index must be created with the PATH_SECTION_GROUP for the operator to work. |
INPATH |
(none) |
INPATH |
to do path searching in XML documents; index must be created with the PATH_SECTION_GROUP for the operator to work. |
MINUS |
- |
MINUS |
to search for documents that contain one query term such that the presence of a second query term causes a lower search rank |
NEAR |
; |
NEAR |
to return a search score based on the proximity of two or more query items; higher scores result from query items that are physically closer together |
NOT |
~ |
NOT |
to search for documents that contain one query and not another |
NT |
(none) |
Narrower Term |
to expand a query to include all the lower level terms defined in the thesaurus as narrower terms for term |
NTG |
(none) |
Narrower Term Generic |
to expand a query to include all the lower level terms defined in the thesaurus as narrower generic terms for term |
NTI |
(none) |
Narrower Term Instance |
to expand a query to include all the lower level terms defined in the thesaurus as narrower instance terms for term |
NTP |
(none) |
Narrower Term Partitive |
to expand a query to include all the lower level terms defined in the thesaurus as narrower partitive terms for term |
OR |
| |
OR |
to search for documents that contain at least one occurrence of any of the query items |
PT |
(none) |
Preferred Term |
to replace a term in a query with the preferred term that has been defined in a thesaurus for the term |
RT |
(none) |
Related Term |
to expand a query to include all related terms that have been defined in a thesaurus for the term |
(none) |
$ |
stem |
to search for terms that have the same linguistic root as the query term |
(none) |
! |
soundex |
to expand queries to include words that have similar sounds |
SQE |
(none) |
Stored Query Expression |
to call a stored query expression created with the CTX_QUERY.STORE_SQE procedure |
SYN |
(none) |
Synonym |
to expand a query to include all the terms that have been defined in a thesaurus as synonyms for the specified term |
(none) |
> |
threshold |
at the expression level to eliminate documents in the result set that search score below a threshold number; at the query term level to select a document based on how a term scores in the document |
TR |
(none) |
Translation Term |
to expand a query to include all defined foreign language equivalent terms |
TRSYN |
(none) |
Translation Term Synonym |
to expand a query to include all the defined foreign equivalents of the query term, the synonyms of query term, and the foreign equivalents of the synonyms |
TT |
(none) |
Top Term |
to replace a term in a query with the top term that has been defined for the term in the standard hierarchy (BT, BT) in a thesaurus |
(none) |
* |
weight |
to multiply the search score by a given factor for a query item |
(none) |
% |
wildcard character (multiple) |
to specify that any characters can appear in multiple positions represented by the wildcard |
(none) |
_ |
wildcard character (single) |
to specify a single position in which any character can occur |
WITHIN |
(none) |
WITHIN |
to narrow a query down into document sections (zone sections, field sections, attributes sections, sentence sections, or paragraph sections)0 |
|
|
|
|
|
|
|
|
There are different groups of precedence orders. |
|||
|
Precedence order #1 (operators) |
|
|
|
|
EQUIV (=) |
|
|
|
NEAR (;) |
|
|
|
weight (*), threshold (>) |
|
|
|
MINUS (-) |
|
|
|
NOT (~) |
|
|
|
WITHIN |
|
|
|
AND (&) |
|
|
|
OR (|) |
|
|
|
ACCUM (,) |
|
|
|
|
|
|
|
|
|
|
Precedence order #2 (operators and characters) |
|
|
|
|
Wildcard Characters |
|
|
|
ABOUT |
|
|
|
stem ($) |
|
|
|
Fuzzy |
|
|
|
soundex (!) |
|
|
|
|
|
|
|
|
|
|
Precedence order #3 (other operators) |
|
|
|
|
no sense of precedence |
|
|
|
|
|
|
|
|
|
Precedence can be altered by using the grouping characters: (, ), [, and ]. |
|||
|
w1 & w2 | w3 as opposed to w1 & (w2 | w3) |
|
|