Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÈ«ÎÄË÷Òý֮ͣÓôʵÄͨÅä·û¹¦ÄÜ

È«ÎÄË÷ÒýÍ£ÓôʵÄÉèÖÃÔÚÇ°ÃæµÄÎÄÕÂÖÐÒѾ­½éÉܹýÁË£¬ÕâÀï¼òµ¥ËµÃ÷¼Ç¼һÏÂÍ£ÓôÊÔÚ²éѯʱºòÐèҪעÒâµÄµØ·½¡£
Oracle10gÖУ¬Èç¹û°²×°ÓïÑÔΪÖÐÎÄ£¬Ä¬ÈϵÄLEXERΪCHINESE_VGRAM_LEXER£¬Ä¬ÈϵÄÍ£ÓôÊÓïÑÔҲΪÖÐÎÄ¡£ÕâÆªÍ¨¹ý¶Ô±ÈÖÐÎÄ»·¾³ºÍÓ¢ÎÄ»·¾³À´ËµÃ÷Í£ÓôʲéѯµÄÒ»Ð©ÌØµã¡£
SQL> show user
USER is "MYUSER"
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'This example test stopword.');
1 row created.
SQL> INSERT INTO T VALUES (2, 'Oracle9i chinese language environment default stopword are english.');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> CREATE INDEX IND_T_DOCS ON T(DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Index created.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'This') > 0;
no rows selected
Ó¢ÎÄ»·¾³ÏÂÔÊÐíµ¥¶À²éѯͣÓôʣ¬µ«ÊDz»»á·µ»Ø½á¹û¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'are english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'is english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'stopword are english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'stopword is english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'are stopword') > 0;
ID DOCS
--- --------------------------------------------------
1 This example test stopword.
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, '


Ïà¹ØÎĵµ£º

oracle»ù±¾²Ù×÷

describe  TABLE_NAME;   --ÃèÊö
----------------------------------------------------------------
create table as select XXXXXX
insert into TABLE_NAME (reac_1,reac_2.....) values(v1,v2)
insert into TABLE_NAME (select * from ..........)
update TABLE_NAME set reac_1=v1,.............. ......

´´½¨oracle dblink&sql²Ù×÷²»Í¬Êý¾Ý¿âµÄ±í

 
¡¡¡¡Á½Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
¡¡¡¡ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
¡¡¡¡´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
¡¡¡¡1¡¢ÒѾ­ÅäÖñ¾µØ·þÎñ
ÒÔÏ ......

oracleÈ«ÎÄË÷ÒýÖ®WORDLIST PREFERENCE

OracleÈ«ÎÄË÷ÒýµÄWORDLISTÊôÐÔÓÃÀ´ÉèÖÃÄ£ºý²éѯºÍͬ´Ê¸ù²éѯ£¬ÁíÍâWORDLISTÊôÐÔ»¹Ö§³ÖͨÅä·û²éѯ¡£
OracleµÄWORDLISTÊôÐÔÖ»ÓÐBASIC_WORDLISTÒ»ÖÖ£¬ÏÂÃæ¿´Ò»¸öBASIC_WORDLISTµÄÀý×Ó£º
1.Stemmer attributeÊÇÓÃÀ´²éѯÓôʸùµÄÊý¾Ý
SQL> create table stemmer_tbl(id number primary key,docs clob);
Table created.
S ......

oracleÈ«ÎÄË÷ÒýÖ®STOPLIST_ CTXCAT Ë÷Òý_INDEX SET

ÕâÆªÎÄÕ½éÉܵÄÊÇORACLE CTXCATË÷ÒýµÄINDEX SET£¬Ò²ÊÇCTXCATË÷ÒýÌØÓеÄÊôÐÔ¡£
CTXCAT
Ë÷ÒýÊÇCONTEXTË÷ÒýµÄ¼ò»¯°æ£¬CTXCATË÷ÒýÖ§³ÖµÄPREFERENCE°üÀ¨£ºLEXER¡¢STOPLIST¡¢WORDLISTºÍSTORAGE
²ÎÊý¡£²»Ö§³ÖÆäËûµÄ²ÎÊýÈ磺DATASTORE¡¢FILTER¡¢SECTION
GROUP¡£ËäȻ֧³ÖLEXERµ«²»Ö§³ÖTHEME²éѯ£¬¶øÇÒ²»Ö§³ÖFORMAT¡¢CHARSETºÍLAN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ