課程

/數(shù)據(jù)庫

/Oracle

/Oracle數(shù)據(jù)庫開發(fā)必備利器之SQL基礎(chǔ)

CREATE?TRIGGER?TIGER_ID_NUM?BEFORE?INSERT?ON?USER_INFO?FOR?EACH?ROW?WHEN?(NEW.ID_NUM?IS?NULL)
BEGIN?
SELECT?SEQ_ID_NUM.nextval?INTO:?NEW.ID_NUM?FROM?dual;
END;