使用前,必需对contains了解
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/cdefaul6.htm#1007516终于找到了,对你有帮助:
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/query3.htm#1007080
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/query4.htm#1007428
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/cdefaul6.htm#1007516终于找到了,对你有帮助:
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/query3.htm#1007080
http://gigabase.idi.ntnu.no/oradoc/text.901/a90122/query4.htm#1007428
Use the AND operator to search for documents that contain at least one occurrence of each of the query terms. Syntax
Syntax Description
term1&term2 term1 and term2
Returns documents that contain term1 and term2. Returns the minimum score of its operands. All query terms must occur; lower score taken.
Examples
To obtain all the documents that contain the terms blue and black and red, issue the following query: 'blue & black & red'Notes
In an AND query, the score returned is the score of the lowest query term. In the example above, if the three individual scores for the terms blue, black, and red is 10, 20 and 30 within a document, the document scores 10.
---------------------------------------------------------------------------------wildcards (% _)
Wildcard characters can be used in query expressions to expand word searches into pattern searches. The wildcard characters are: Wildcard Character Description
%
The percent wildcard specifies that any characters can appear in multiple positions represented by the wildcard.
_
The underscore wildcard specifies a single position in which any character can occur. Note:
When a wildcard expression translates to a stopword, the stopword is not included in the query and not highlighted by CTX_DOC.HIGHLIGHT or CTX_DOC.MARKUP. Right-Truncated Queries
Right truncation involves placing the wildcard on the right-hand-side of the search string. For example, the following query expression finds all terms beginning with the pattern scal: 'scal%'Left- and Double-Truncated Queries
Left truncation involves placing the wildcard on the left-hand-side of the search string. To find words such as king, wing or sing, you can write your query as follows: '_ing'
You can write this query more generally as: '%ing'
You can also combine left-truncated and right-truncated searches to create double-truncated searches. The following query finds all documents that contain words that contain the substring %benz% '%benz%'Improving Double-Truncated Query Performance
When your wildcard queries are left- and double-truncated, you can improve query performance by creating a substring index. Substring indexes improve the query performance for all types of left-truncated wildcard searches such as %ed, _ing, or %benz%.
http://otn.oracle.com/software/products/intermedia/content.html
或者先要下载这个
SELECT AB FROM PATENTINFOR WHERE CONTAINS (AB, '一')>0 and contains (AB, '葡萄')>0;目标,查出既包含。。,又包含。。的内容