oracle½¨Á¢´¥·¢Æ÷ ʵÏÖ×ÔÔöʵÀý

create table TN_TEST(
       username varchar2(32),
       userpass varchar2(32),
       version  number
)
ÒªÇóÒ»:
TN_TEST±íÖÐ×Ö¶Îversion
ÿ´ÎÐÞ¸ÄTN_TEST±íÔò½²version×Ô¶¯¼ÓÒ»
½¨Á¢´¥·¢Æ÷Óï¾ä:
create trigger add_ver before update on TN_TEST for each row begin
:new.version:=:old.version+1;
end;
ÒªÇó¶þ:
Óô¥·¢Æ÷ºÍÐòÁÐʵÏÖ×ÔÔö
/*Ê×ÏÈ´´½¨ÐòÁÐ*/
create sequence SEQ_TN_TEST increment by 1 start with 1 MAXVALUE  9999999
/*´´½¨´¥·¢Æ÷ʵÏÖ×ÔÔö*/
Create Trigger up_ver Before
Update On TN_TEST
For Each Row begin
select SEQ_TN_TEST.nextval into :new.version
from dual;
end up_ver;
/*´¥·¢Æ÷½áÊø*/