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
Ïà¹ØÎĵµ£º
¡¡¡¡Á½Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
¡¡¡¡ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
¡¡¡¡´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
¡¡¡¡1¡¢ÒѾÅäÖñ¾µØ·þÎñ
ÒÔÏ ......
OracleÈ«ÎÄË÷ÒýµÄSTORAGEÊôÐÔÊÇΪÁ˸øÈ«ÎÄË÷ÒýÉú³ÉµÄ¸¨Öú±íÉèÖô洢²ÎÊýµÄ¡£
OracleµÄÈ«ÎÄË÷Òý»áÉú³ÉÒ»ÕÅ»ò¶àÕŸ¨Öú±í£¬ÓÉÓÚÕâЩ±íÊÇOracle×Ô¶¯Éú³ÉµÄ£¬Óû§Ã»Óа취ֱ½ÓÉèÖÃÕâЩ±íºÍË÷ÒýµÄÎïÀí²ÎÊý£¬Òò´ËOracleÌṩÁËSTORAGEÊôÐÔ£¬×¨ÃÅÉèÖÃÕâЩ¸¨Öú±íºÍË÷ÒýµÄÎïÀí²ÎÊý¡£
SQL> SELECT * from TAB;
TNAME ......
OracleµÄÈ«ÎÄË÷Òý³ýÁËÖ§³ÖÎÄ×ÖÆ¥Åä²éѯ£¬»¹Ö§³Ö¶ÔÎÄÕºÒåµÄ²éѯ¡£ÕâÊÇͨ¹ýABOUT²Ù×÷ʵÏֵġ£
OracleĬÈÏÇé¿öÏÂÖ§³ÖÓ¢Îĺͷ¨ÎĵÄÎÄÕºÒåÖ§³Ö¡£ÆäËûÓïÑÔ¿ÉÒÔÌí¼Óͨ¹ýÓû§×Ô¶¨ÒåµÄÓïÑÔ¿âÀ´ÊµÏÖÏàÓ¦µÄ¹¦ÄÜ¡£
ÔÚ
Õâ֮ǰÐèÒªÏȰ²×°Companion CD µÄOracle Database 10g Products Installation
Type,ÆäÖаüÀ¨ÁËOracle Text Su ......
ÔÚ´ò°üoralce¿Í»§¶Ëºó£¬¾³£»áÓöµ½Õâ¸öÎÊÌâ“specified class not registered in registry”
½â¾ö°ì·¨£º
ÕâÊÇÒòΪÓм¸¸öÁ´½Ó¿âdll»òocxûע²áµÄÔÒò£¬¾±¾È˲âÊÔΪÒÔÏÂ5¸öÎļþ£º
......