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

                                                 

原文地址:https://www.cnblogs.com/yanjunwu/p/2709146.html