建立sequence
create sequence SQU_2
minvalue 1
maxvalue 9999999999
start with 121
increment by 1
cache 20
order;
触发器create or replace trigger aaa
before insert on a
for each row
begin
SELECT squ_2.nextval INTO :new.ID FROM DUAL;
end aaa;
ok了
create sequence SQU_2
minvalue 1
maxvalue 9999999999
start with 121
increment by 1
cache 20
order;
触发器create or replace trigger aaa
before insert on a
for each row
begin
SELECT squ_2.nextval INTO :new.ID FROM DUAL;
end aaa;
ok了
increment by 1
start with 1
maxvalue 999999999
cycle;当向表中插入数据时,SQL语句写法如下:SQL> insert into 表名 values(序列名.nextval,列1值,列2值);