Oracle³£Óýű¾Ê¾Àý
CREATE SEQUENCE s_report_id INCREMENT BY 1 MAXVALUE 999999 START WITH 1;
CREATE SEQUENCE checkup_no_seq NOCYCLE MAXVALUE 999999 START WITH 2;
CREATE OR REPLACE TRIGGER bef_ins_report
BEFORE INSERT ON busi_report
referencing old as old new as new
FOR EACH ROW
BEGIN
new.rep_id = s_report_id.nextval;
END;
CREATE OR REPLACE TRIGGER bef_ins_report
BEFORE INSERT ON busi_report
FOR EACH ROW
DECLARE next_id NUMBER;
BEGIN
SELECT s_report_id.NEXTVAL INTO next_id from dual;
:new.rep_id := next_id;
END;
-------------------------------------------------------------------------
-----´¥·¢Ê¾Àý-----
--------------------------------------------------------------------------
CREATE OR REPLACE TRIGGER set_checkup_no
BEFORE INSERT ON checkup_history
FOR EACH ROW DECLARE next_checkup_no NUMBER;
BEGIN
SELECT checkup_no_seq.NEXTVAL INTO next_checkup_no from dual;
:new.checkup_no := next_checkup_no;
END;
--------------------------------------------------------------------------
-----½¨±íɾ±í-----
--------------------------------------------------------------------------
CREATE TABLE busi_report
(
rep_id number(6) NOT NULL,
content varchar2(80) ,
adder varchar2(20) ,
rep_src varchar2(20) ,
add_time date ,
rep_time date ,
PRIMARY KEY (rep_id)
);
drop table BUSI_REPORT
select * from busi_report
insert into busi_report (rep_id, content, adder, rep_src, add_time, rep_time) values(21,'ÌìPÓÐÓê','zss','adf',to_date('2002-3-2 12:31
Ïà¹ØÎĵµ£º
SQL> create table test2(s1 varchar(10),s2 varchar2(10));
±íÒÑ´´½¨¡£
SQL> insert into test2 values('11','111');
ÒÑ´´½¨ 1 ÐС£
SQL> insert into test2 values('22','222');
ÒÑ´´½¨ 1 ÐС£
SQL> CREATE OR REPLACE PACKAGE test222 AS
2 TYPE t_cursor IS REF CURSOR;
3 procedure p_tes ......
¡¡¡¾IT168 ¼¼ÊõÎĵµ¡¿ÈκÎÊÂÇé¶¼ÓÐËüµÄÔ´Í·£¬Òª½â¾öÎÊÌ⣬ҲµÃ´ÓÔ´Í·¿ªÊ¼£¬Ó°ÏìORACLEÐÔÄܵÄÔ´Í··Ç³£¶à£¬Ö÷Òª°üÀ¨ÈçÏ·½Ã棺Êý¾Ý¿âµÄÓ²¼þÅäÖÃ:CPU¡¢ÄÚ´æ¡¢ÍøÂçÌõ¼þ¡£
¡¡¡¡1. CPU:ÔÚÈκλúÆ÷ÖÐCPUµÄÊý¾Ý´¦ÀíÄÜÁ¦ÍùÍùÊǺâÁ¿¼ÆËã»úÐÔÄܵÄÒ»¸ö±êÖ¾£¬²¢ÇÒORACLEÊÇÒ»¸öÌṩ²¢ÐÐÄÜÁ¦µÄÊý¾Ý¿âϵͳ£¬ÔÚCPU·½ÃæµÄÒªÇó¾Í¸ü¸ßÁË£¬Èç¹ûÔ ......
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 ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄDATASTOREÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄFILTERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔÖ÷ÒªÊÇÕë¶Ô¾ßÓÐÒ»¶¨¸ñʽµÄÎĵµ£¬Oracle¸ù¾ÝFILTERµÄÉ趨À´¹ýÂËÄÇЩ²»ÊôÓÚÎÄÕÂÄÚÈݵIJ¿·Ö¡£
FILTERÊôÐÔ°üº¬µÄÊôÐÔÓУºCHARSET_FILTER¡¢INSO_FILTER¡¢NULL_FILTER¡¢USER_FILTER¡¢PROCEDURE_FILTER¼¸ÖÖ¡£
ÕâÀïÈÔÈ»´ÓFILTER ......
ÕâÆªÎÄÕ½éÉܵÄÊÇORACLE CTXCATË÷ÒýµÄINDEX SET£¬Ò²ÊÇCTXCATË÷ÒýÌØÓеÄÊôÐÔ¡£
CTXCAT
Ë÷ÒýÊÇCONTEXTË÷ÒýµÄ¼ò»¯°æ£¬CTXCATË÷ÒýÖ§³ÖµÄPREFERENCE°üÀ¨£ºLEXER¡¢STOPLIST¡¢WORDLISTºÍSTORAGE
²ÎÊý¡£²»Ö§³ÖÆäËûµÄ²ÎÊýÈ磺DATASTORE¡¢FILTER¡¢SECTION
GROUP¡£ËäȻ֧³ÖLEXERµ«²»Ö§³ÖTHEME²éѯ£¬¶øÇÒ²»Ö§³ÖFORMAT¡¢CHARSETºÍLAN ......