建议使ç¨å
¨ææ£ç´¢(FULL TEXT SEARCH)ã
ç¨ORACLE8iä¸çintermedia textæè
oracle9içtext对CLOBå段建ä¸ä¸ªCTXSYS.CONTEXT ç±»åçç´¢å¼, ç¶åå¨æ¥è¯¢æ¶ç¨CONTAINä½ä¸ºæ¥è¯¢æ¡ä»¶.代ç å¦ä¸ï¼--å建表CREATE TABLE tb_clob(
userid NUMBER PRIMARY KEY,
text CLOB)ï¼--建ç«ç´¢å¼CREATE INDEX search_idx
ON tb_clob(text)
INDEXTYPE IS ctxsys.CONTEXTï¼--æ¥è¯¢SELECT COUNT(*)
温馨提示:答案为网友推荐,仅供参考