使用前,必需对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
解决方案 »
- oracle一次插入多条数据报错,求解???
- oraociei10.dll 安装
- 更改用户锁定状态不成功
- 高分解决oracle时间相减问题
- 用JDBC向ORACLE中插入数据的问题
- 我怎么进不去“企业管理器”呀
- 在配置资料库时候,错误 ORA-12705:invalid or unknown NLS parameter value specified
- 请问,在ORACLE 数据库中执行简单的SQL语句,是不是不支持左取字符--在线等候!
- 请问那位高手有如何在P4+windowXP下安装oracle的经验
- 问下各位大神在linux32位 下安装oracle 11g时候出现的问题。。。
- 请问安装ORACLE应该怎样规划表空间啊?
- 问个菜菜的问题:关于Oracle中创建表的问题
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;目标,查出既包含。。,又包含。。的内容