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

 

                                                 

posted @ 2012-09-30 11:53  NewObject_1  阅读(213)  评论(0编辑  收藏  举报