1.建立序列:
create sequence seq_test1;
2.建立表:
create table tb_test1(id int , name varchar(10)) ;
3.建立触发器:
create trigger test1_ins
before insert on tb_test1
for each row
begin
:new.id := seq_test1.nextval ;
end ;
1.建立序列:
create sequence seq_test1;
2.建立表:
create table tb_test1(id int , name varchar(10)) ;
create trigger test1_ins
before insert on tb_test1
for each row
begin
:new.id := seq_test1.nextval ;
end ;