创建序列:create sequence SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 61
increment by 1
cache 30
order;使用:insert into tname values(SEQ.nextval,其它字段值)
minvalue 1
maxvalue 999999999999999999999999999
start with 61
increment by 1
cache 30
order;使用:insert into tname values(SEQ.nextval,其它字段值)
CREATE SEQUENCE EXAM_NO_SEQ
START WITH 1484
MAXVALUE 9999999999
MINVALUE 1
CYCLE
CACHE 20
NOORDER;
//获取申请序号
SELECT exam_no_seq.nextval FROM dual
把这个序列号负值给表中的自动增长的字段就可以了.
BEFORE INSERT ON a.a
FOR EACH ROW
BEGIN
IF (:NEW.ID IS NULL) THEN
SELECT SEQ_ID.NEXTVAL INTO :NEW.ID FROM DUAL;
END IF;
END;
/
CSDN小助手是一款脱离浏览器也可以访问Csdn论坛的软件
界面:http://blog.csdn.net/Qqwwee_Com/archive/2005/11/05/523395.aspx
下载:http://szlawbook.com/csdnv2