oracle自增长 mysql sequence
让oracle实现mysql的风格,自增长:
给oracle增加一个触发器:代码如下:
CREATE OR REPLACE TRIGGER aaa BEFORE INSERT ON Movie FOR EACH ROW
BEGIN
SELECT MovieSeq.NEXTVAL INTO :new.id FROM DUAL;
END aaa;
. RUN;
___________________________________________________________________________
给MySQL增加Sequence管理功能
见:http://www.2cto.com/database/201202/119528.html