使用序列
create sequence s_country_id increment by 1 start with 1 maxvalue 999999999;
INSERT INTO addid (id)
VALUES (s_country_id.nextval);
create sequence s_country_id increment by 1 start with 1 maxvalue 999999999;
INSERT INTO addid (id)
VALUES (s_country_id.nextval);
Create Sequence SeOperationID
Start With 1
Increment By 1;2.建表
CREATE TABLE RZ_Info(
OperationID number PRIMARY KEY,
OprationType varchar2(20),
OperationTime date DEFAULT SYSDATE,
OperationMan varchar2(4)); 3.建触发器
CREATE OR REPLACE TRIGGER RZ_Info_RIGGER
BEFORE INSERT
ON RZ_Info FOR EACH ROW
BEGIN
SELECT SeOperationID.NEXTVAL INTO :NEW.OperationID FROM DUAL;
END;
/4.插入值,重复多次
INSERT INTO RZ_Info(OprationType,OperationMan)
VALUES('系统初始化','0000');5.查询
select * from RZ_Info;
create sequence 序列名 start with 1
INSERT INTO addid (id)
VALUES (序列名.nextval)即可