create sequence seq_no start with 1; insert into recv values (seqno.nextval,'**','**',....);
create sequence seq start with 1 minvalue 1 maxvalue 9999999999 nocycle; insert into table_name(id,name) values(seq.nextval,'test');
假设表 auto(aa int,bb varchar2(50)) create sequence start with 1 increment by 1;create or replace trigger set_no before insert on auto for each row declare sn number(5); begin select myseq.nextval into sn from dual; :new.aa:=sn; end; / insert into auto values(33,'ahofha');
insert into recv values (seqno.nextval,'**','**',....);
start with 1
minvalue 1
maxvalue 9999999999
nocycle;
insert into table_name(id,name) values(seq.nextval,'test');
create sequence
start with 1
increment by 1;create or replace trigger set_no
before insert on auto
for each row
declare
sn number(5);
begin
select myseq.nextval into sn from dual;
:new.aa:=sn;
end;
/
insert into auto values(33,'ahofha');