我前两天还建了,现在忘了。
我的sequence是这样写的:create sequence admin_clear
increment by 2
start with 100000
nomaxvalue
nocycle
cache 10;
现在不是建表吗,create talbe info_account{
id number(10) primary key,
user_id number(10) not null,
money number(18) not null
}
大体就这样,我想让id和admin_clear 关联,id会自增,现在忘了,希望大侠们帮帮忙;
我在线等;
我的sequence是这样写的:create sequence admin_clear
increment by 2
start with 100000
nomaxvalue
nocycle
cache 10;
现在不是建表吗,create talbe info_account{
id number(10) primary key,
user_id number(10) not null,
money number(18) not null
}
大体就这样,我想让id和admin_clear 关联,id会自增,现在忘了,希望大侠们帮帮忙;
我在线等;
create table t(pk number primary key,...);
create sequence t_seq;
create trigger t_trigger before insert on t for each row
begin
select t_seq.nextval into :new.pk from dual;
end;
create trigger t_trigger before insert on t for each row
begin
select t_seq.nextval into :new.pk from dual;
end;
begin
select admin_clear.nextval into :new.id from dual;
end;