Oracle ÈçºÎ¶¨Òå×Ô¶¯ÔöÁ¿autocreamentµÄÖ÷¼üID?

MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
  ID           
INTEGER                         NOT NULL,
  GAME_DATE    
DATE                            NOT NULL,
  START_TIME    DATE,

  END_TIME      DATE,
  GAME_RULE_ID  INTEGER
)
ÎÒÏë²åÈëʱ²»±ØÖ¸³öId
INSERT INTO game(game_date, start_time, Game_rule_id)
VALUES (to_date(‘2003/05/03′, ‘yyyy/mm/dd’), to_date(‘21:02:44′,
‘hh24:mi:ss’), 1) £»
Ê×Ïȶ¨Òåsequence
create sequence game_sequence
start with 1
increment
by 1;
È»ºó¶¨Òåtrigger
create TRIGGER game_trigger
BEFORE INSERT
ON game
REFERENCING
NEW AS NEW
FOR EACH ROW
BEGIN
SELECT
game_sequence.nextval INTO :NEW.ID from dual;
END;
²é¿´ÒѾ­´æÔÚµÄsequenceºÍtrigger
SELECT sequence_name from user_sequences;
SELECT trigger_name from user_triggers;
ɾ³ýÒѾ­¶¨ÒåµÄsequenceºÍtrigger
DROP sequence game_sequence;
DROP trigger game_trigger;
½ûÓúÍÆôÓÃtrigger
ALTER trigger game_trigger disable;
ALTER trigger game_trigger enable;