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

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.
SQL> insert into stemmer_tbl values(111,'We are testing the Stemmer attribute option');
1 row created.
SQL> insert into stemmer_tbl values(112,'The girl sang like a frog');
1 row created.
SQL> insert into stemmer_tbl values(113,'My import is committing too often');
1 row created.
SQL> commit;
Commit complete.
--
-- Basic WordList Stemmer attribute
-- This example uses English for Stemming.
-- Language choices are: NULL,ENGLISH,DERIVATIONAL,DUTCH,FRENCH,GERMAN,ITALIAN
-- and SPANISH. By default we use the language of the database. If the
-- database is not one of the listed languages then we choose NULL for stemmer
-- and default for fuzzy
--
SQL> begin
2 Ctx_Ddl.Create_Preference('STEMMER_PREF', 'BASIC_WORDLIST');
3 ctx_ddl.set_attribute('STEMMER_PREF','STEMMER','ENGLISH');
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> create index stemmer_idx on stemmer_tbl ( docs )
2 indextype is ctxsys.context
3 parameters ('Wordlist STEMMER_PREF');
Index created.
SQL> column docs format a20
SQL> select id,docs,score(1) from stemmer_tbl
2 where contains ( docs, '$test',1 ) > 0;
ID DOCS SCORE(1)
---------- -------------------- ----------
111 We are testing the S 4
temmer attribute opt
ion
SQL> select id,docs,score(1) from stemmer_tbl
2 where contains ( docs, '$sing',1) >0;
ID DOCS SCORE(1)
---------- -------------------- ----------
112 The girl sang like a 4
frog
µÚÒ»¸ö²éѯÊDzétestµÄÕÒ³ötesting£¬Õâ¸ö²»Ì«Ã÷ÏÔ£»µÚ¶þ¸öÊÇÕҴʸùÊÇsingµÄÊý¾Ý£¬ÕÒµ½ÁËsangµÄÕâÒ»ÐÐÊý¾Ý¡£


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾

http://hi.baidu.com/james_yulei/blog/item/7cc8c834063d6f3a0b55a920.html
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
2009-12-21 18:04
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
²Ù×÷ϵͳ£ºLinux
Êý¾Ý¿â£ºoracle9.2.0.4
1¡¢Êý¾Ý¿âÉèÖÃΪ¹éµµ·½Ê½
2¡¢Êý¾Ý¿âµÄ±¸·Ý½Å±¾
db_full_backup.sh £ºÊý¾Ý¿âÈ«±¸½Å±¾
db_l0_backup.sh £ºÊý¾Ý¿ ......

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ÎÊÌâ»ã×Ü

Óöµ½µÄһЩOracleµÄÁãËéÎÊÌ⣺
1¡¢Ê¹ÓÃ×Ô¶¨ÒåÒì³££¬raise_application_error(Òì³£±àºÅ£¬Òì³£ÐÅÏ¢)¡£
     A¡¢Òì³£±àºÅ×¢Òâ²»Òª³¬³¤£¬Ò»°ãµ½5λ
     B¡¢Òì³£ÐÅÏ¢ÊÇÒ»¸ö×Ö·û´®ÐÅÏ¢
     C¡¢ÅäºÏ´æ´¢¹ý³ÌÖÐexceptionʹÓà ......

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ÐÔÄܵ÷ÓÅÔ­Ôò

¡¡¡¾IT168 ¼¼ÊõÎĵµ¡¿ÈκÎÊÂÇé¶¼ÓÐËüµÄÔ´Í·£¬Òª½â¾öÎÊÌ⣬ҲµÃ´ÓÔ´Í·¿ªÊ¼£¬Ó°ÏìORACLEÐÔÄܵÄÔ´Í··Ç³£¶à£¬Ö÷Òª°üÀ¨ÈçÏ·½Ã棺Êý¾Ý¿âµÄÓ²¼þÅäÖÃ:CPU¡¢ÄÚ´æ¡¢ÍøÂçÌõ¼þ¡£
¡¡¡¡1. CPU:ÔÚÈκλúÆ÷ÖÐCPUµÄÊý¾Ý´¦ÀíÄÜÁ¦ÍùÍùÊǺâÁ¿¼ÆËã»úÐÔÄܵÄÒ»¸ö±êÖ¾£¬²¢ÇÒORACLEÊÇÒ»¸öÌṩ²¢ÐÐÄÜÁ¦µÄÊý¾Ý¿âϵͳ£¬ÔÚCPU·½ÃæµÄÒªÇó¾Í¸ü¸ßÁË£¬Èç¹ûÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ