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
Ïà¹ØÎĵµ£º
Óöµ½µÄһЩOracleµÄÁãËéÎÊÌ⣺
1¡¢Ê¹ÓÃ×Ô¶¨ÒåÒì³££¬raise_application_error(Òì³£±àºÅ£¬Òì³£ÐÅÏ¢)¡£
A¡¢Òì³£±àºÅ×¢Òâ²»Òª³¬³¤£¬Ò»°ãµ½5λ
B¡¢Òì³£ÐÅÏ¢ÊÇÒ»¸ö×Ö·û´®ÐÅÏ¢
C¡¢ÅäºÏ´æ´¢¹ý³ÌÖÐexceptionʹÓà ......
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 Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊ ......
OracleµÄÈ«ÎÄË÷Òý³ýÁËÖ§³ÖÎÄ×ÖÆ¥Åä²éѯ£¬»¹Ö§³Ö¶ÔÎÄÕºÒåµÄ²éѯ¡£ÕâÊÇͨ¹ýABOUT²Ù×÷ʵÏֵġ£
OracleĬÈÏÇé¿öÏÂÖ§³ÖÓ¢Îĺͷ¨ÎĵÄÎÄÕºÒåÖ§³Ö¡£ÆäËûÓïÑÔ¿ÉÒÔÌí¼Óͨ¹ýÓû§×Ô¶¨ÒåµÄÓïÑÔ¿âÀ´ÊµÏÖÏàÓ¦µÄ¹¦ÄÜ¡£
ÔÚ
Õâ֮ǰÐèÒªÏÈ°²×°Companion CD µÄOracle Database 10g Products Installation
Type,ÆäÖаüÀ¨ÁËOracle Text Su ......
È«ÎÄË÷ÒýÍ£ÓôʵÄÉèÖÃÔÚÇ°ÃæµÄÎÄÕÂÖÐÒѾ½éÉܹýÁË£¬ÕâÀï¼òµ¥ËµÃ÷¼Ç¼һÏÂÍ£ÓôÊÔÚ²éѯʱºòÐèҪעÒâµÄµØ·½¡£
Oracle10gÖУ¬Èç¹û°²×°ÓïÑÔΪÖÐÎÄ£¬Ä¬ÈϵÄLEXERΪCHINESE_VGRAM_LEXER£¬Ä¬ÈϵÄÍ£ÓôÊÓïÑÔҲΪÖÐÎÄ¡£Õâƪͨ¹ý¶Ô±ÈÖÐÎÄ»·¾³ºÍÓ¢ÎÄ»·¾³À´ËµÃ÷Í£ÓôʲéѯµÄһЩÌص㡣
SQL> show user
USER is "MYUSER" ......