oracleÈ«ÎÄË÷ÒýÖ®LEXER
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâƪÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲÍþÓï¡¢ÈðµäÓïµÈµÈ¡£
BASIC_LEXER³ýÁËÖ§³Ö¶àÖÖÓïÑÔ£¬»¹¿ÉÒÔÉèÖöàÖÖÊôÐÔ¡£±ÈÈçÕâ¸öÀý×ÓÖнéÉܵÄË÷ÒýµÄ´óСдÉèÖãº
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
±íÒÑ´´½¨¡£
SQL> INSERT INTO T VALUES (1, 'This is a example for the basic lexer');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (2, 'And we make a example for a mixed spell indexs.');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (3, 'So the word in UPPER format must be query in UPPER');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (4, 'And Mixed Spell Word must be Query in Mixed.');
ÒÑ´´½¨ 1 ÐС£
SQL> COMMIT;
Ìá½»Íê³É¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('LEXER CTXSYS.BASIC_LEXER');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'MIXED') > 0;
ID
----------
4
2
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CONN CTXSYS/CTXSYS@YANGTK
ÒÑÁ¬½Ó¡£
SQL> BEGIN
2 CTX_DDL.CREATE_PREFERENCE('TEST_BASIC_LEXER', 'BASIC_LEXER');
3 CTX_DDL.SET_ATTRIBUTE('TEST_BASIC_LEXER', 'MIXED_CASE', 'YES');
4 END;
5 /
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL> CONN YANGTK/YANGTK@YANGTK
ÒÑÁ¬½Ó¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('LEXER CTXSYS.TEST_BASIC_LEXER');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'MIXED') > 0;
δѡ¶¨ÐÐ
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'Mixed') > 0;
ID
----------
4
Èç¹û²»½øÐÐÉèÖã¬OracleÔÚ½¨Á¢Ë÷Òýʱ»á½«ËùÓеÄ×Öĸ±äΪ´óд¡£Èç¹û½øÐÐÁËÉèÖ㬿ÉÒÔʹË÷ÒýÇø·Ö´óСд
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄBASIC_LEXERÊôÐÔ£¬Õâƪ½éÉÜOracleÖÐÎÄÓï·¨ÊôÐÔCHINESE_LEXERºÍCHINESE_VGRA
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
--ʹÓÃDBA´´½¨Á½¸öÓû§
create user gubo identified by gubo;
create user gubo2 identified by gubo;
--¸øÁ½¸öÓû§Á¬½ÓȨÏÞ
grant create session to gubo;
grant create session to gubo2;
--¸øÆäÖÐÒ»¸öÓû§·ÃÎʱí¿Õ¼äµÄȨÏÞ
grant unlimited tablespace to gubo;
--Á¬½ÓÆäÖÐÓû§£¬´´½¨±í
--conn gubo
......
¡¾IT168 ¼¼ÊõÎĵµ¡¿Ëæ×ÅÍøÂçÓ¦Óú͵ç×ÓÉÌÎñµÄ²»¶Ï·¢Õ¹£¬¸÷¸öÕ¾µãµÄ·ÃÎÊÁ¿Ô½À´Ô½´ó£¬ÈçºÎʹÓÐÏ޵ļÆËã»úϵͳ×ÊԴΪ¸ü¶àµÄÓû§·þÎñ£¿ÈçºÎ±£Ö¤Óû§µÄÏìÓ¦ËٶȺͷþÎñÖÊÁ¿£¿ÕâЩÎÊÌⶼÊôÓÚ·þÎñÆ÷ÐÔÄÜÓÅ»¯µÄ·¶³ë¡£×÷Ϊ½Ï³É¹¦µÄÊý¾Ý¿â³§ÉÌ£¬Oracle¹«Ë¾Êý¾Ý¿âµÄÐÔÄÜÓÅ»¯ÊÇÈçºÎ½øÐеÄ
¡¡¡¡ ÓÅ»¯²ßÂÔ
¡¡¡¡ ΪÁ˱£Ö¤OracleÊý ......
1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date i ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄDATASTOREÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄFILTERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔÖ÷ÒªÊÇÕë¶Ô¾ßÓÐÒ»¶¨¸ñʽµÄÎĵµ£¬Oracle¸ù¾ÝFILTERµÄÉ趨À´¹ýÂËÄÇЩ²»ÊôÓÚÎÄÕÂÄÚÈݵIJ¿·Ö¡£
FILTERÊôÐÔ°üº¬µÄÊôÐÔÓУºCHARSET_FILTER¡¢INSO_FILTER¡¢NULL_FILTER¡¢USER_FILTER¡¢PROCEDURE_FILTER¼¸ÖÖ¡£
ÕâÀïÈÔÈ»´ÓFILTER ......