oracleÈ«ÎÄË÷ÒýÖ®About_INDEX_THEMES²Ù×÷
OracleµÄÈ«ÎÄË÷Òý³ýÁËÖ§³ÖÎÄ×ÖÆ¥Åä²éѯ£¬»¹Ö§³Ö¶ÔÎÄÕºÒåµÄ²éѯ¡£ÕâÊÇͨ¹ýABOUT²Ù×÷ʵÏֵġ£
OracleĬÈÏÇé¿öÏÂÖ§³ÖÓ¢Îĺͷ¨ÎĵÄÎÄÕºÒåÖ§³Ö¡£ÆäËûÓïÑÔ¿ÉÒÔÌí¼Óͨ¹ýÓû§×Ô¶¨ÒåµÄÓïÑÔ¿âÀ´ÊµÏÖÏàÓ¦µÄ¹¦ÄÜ¡£
ÔÚ
Õâ֮ǰÐèÒªÏÈ°²×°Companion CD µÄOracle Database 10g Products Installation
Type,ÆäÖаüÀ¨ÁËOracle Text Supplied Knowledge
Bases£¬·ñÔòÔÚ½¨Á¢º¬ÓÐaboutµÄË÷Òýʱ»á³ö´í¡£Companion CD¿ÉÖ±½ÓÔÚ¹ÙÍøÏÂÔØ£¬°²×°Ò²·Ç³£¼òµ¥¡£
ÏÂÃæ¿´¿´Ó¢ÎÄ»·¾³Ï¼òµ¥µÄABOUT²Ù×÷Ó÷¨£º
SQL> conn myuser/myuser
Connected.
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'You can augment the knowledge base to define concepts and terms specific to your
industry or query application. When you do so, ABOUT queries are more precise for the added concepts.');
1 row created.
SQL> INSERT INTO T VALUES (2, 'ABOUT queries perform best when you create a theme component in your index. Theme
components are created by default for English and French.');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> CREATE INDEX IND_T_DOCS ON T(DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Index created.
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'ABOUT(queries)') > 0;
ID
----------
1
2
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'queries') > 0;
ID
----------
1
2
ĬÈϵÄLEXERÊÇBASIC_LEXER£¬Òò´Ë£¬¿ÉÒÔABOUT²Ù×÷ÒѾ¿ÉÒÔÆð×÷ÓÃÁË£¬µ«ÊÇÓÉÓÚ²ÉÓÃĬÈÏÉèÖã¬ABOUT²éѯµÄ¾«¶È²»¸ß¡£ËäÈ»¿ÉÒÔ²éѯµ½£¬µ«ÊÇÕâ¸öµ¥´Ê±¾Éí¾ÍÊÇÔÚÎÄÕÂÖгöÏֵģ¬Èç¹ûʹÓÃÎÄÕÂÖÐûÓгöÏֵĵ¥´Ê£¬ABOUT»¹ÊDzéѯ²»µ½¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'ABOUT(definition)') > 0;
no rows selected
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'definition') > 0;
no rows selected
Èç¹ûÏ£ÍûÌá¸ßABOUT²Ù×÷µÄ²éѯ¾«¶È£¬¿ÉÒÔÉèÖÃBASIC_LEXERÖеÄINDEX_THEMESÊôÐÔµÄֵΪYES¡£
SQL> BEGIN
2 CTX_DDL.CREATE_PREFERENCE('TEST_ABOUT', 'BASIC_LEXER');
3 CTX_DDL.SET_ATTRIBUTE('TEST_ABOUT', 'INDEX_THEMES', 'YES');
4 CTX_DDL.
Ïà¹ØÎĵµ£º
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µÄÁãËéÎÊÌ⣺
1¡¢Ê¹ÓÃ×Ô¶¨ÒåÒì³££¬raise_application_error(Òì³£±àºÅ£¬Òì³£ÐÅÏ¢)¡£
A¡¢Òì³£±àºÅ×¢Òâ²»Òª³¬³¤£¬Ò»°ãµ½5λ
B¡¢Òì³£ÐÅÏ¢ÊÇÒ»¸ö×Ö·û´®ÐÅÏ¢
C¡¢ÅäºÏ´æ´¢¹ý³ÌÖÐexceptionʹÓà ......
¡¡¡¡Á½Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
¡¡¡¡ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
¡¡¡¡´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
¡¡¡¡1¡¢ÒѾÅäÖñ¾µØ·þÎñ
ÒÔÏ ......
Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊ ......
DATASTOREÊÇFILE_DATASTOREµÄ²âÊÔ
[oracle@rhel140 ~]$ cat OUTPUT.TXT
ORACLE
oracle
[oracle@rhel140 LOG]$ cat EMPXT_000_2012_2680.LOG
SOURCE
ABC
SQL> conn myuser/myuser
Connected.
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'OUT ......