½²½âOracleÊý¾Ý¿â×Ô¶¯Ôö³¤ÁеÄʵÏÖ¹ý³Ì

OracleÊý¾Ý¿â×Ô¶¯Ôö³¤ÁеÄʵÏÖ¹ý³Ì:
¡ô1.´´½¨ÐòÁÐ
 
-- Create sequence
create sequence INNERID
minvalue 1
maxvalue 99999999999999
start with 1
increment by 1
cache 20
order;
 
 
 
¡ô2.--INNERID.currval Ö¸µ±Ç°ÐòÁÐ
      --INNERID.nextval Ö¸ÏÂÒ»¸öÐòÁÐ
 
insert into admin values (INNERID.nextval,'a');
insert into admin values (INNERID.nextval,'b');
insert into admin values (INNERID.nextval,'c');
insert into admin values (INNERID.nextval,'d');
create table admin
(id varchar2(20),name varchar2(10));
 
--²»¶ÏµÄ²åÈëÐòÁеÄÏÂÒ»¸öÖµ.
 
 
¡ô3.´´½¨´¥·¢Æ÷(×¢:´Ë´¦ÎÞ·¨ÉèÖÃidµÄĬÈÏֵΪINNERID.nextval )
 
CREATE OR REPLACE TRIGGER admin_tg
--admin id µÄ´¥·¢Æ÷
BEFORE INSERT ON admin FOR EACH ROW
BEGIN
SELECT INNERID.NEXTVAL INTO :NEW.id from DUAL;
END;
                ²âÊÔÓï¾äÈçÏ£º
 
insert into admin (username) values ( 'zdz');
³É¹¦²åÈëÊý¾Ý,Ôٲ鿴Êý¾Ý,Äã¿ÉÒÔ·¢ÏÖid×Ô¶¯Ôö³¤ÁË,´ËÎÊÌâÖÁ´Ë½â¾ö£¡