Table created SQL> --建序列 SQL> create sequence seq_a_id start with 1 increment by 1;
Sequence created SQL> --建触发器 SQL> create or replace trigger tr_a 2 before insert on a 3 for each row 4 begin 5 select seq_a_id.nextval into :new.id from dual; 6 end; 7 /
Trigger created SQL> --插入数据 SQL> insert into a(name) values('aa');
1 row inserted SQL> insert into a(name) values('bb');
SQL> --建表
SQL> create table a(id number,name varchar2(20));
Table created
SQL> --建序列
SQL> create sequence seq_a_id start with 1 increment by 1;
Sequence created
SQL> --建触发器
SQL> create or replace trigger tr_a
2 before insert on a
3 for each row
4 begin
5 select seq_a_id.nextval into :new.id from dual;
6 end;
7 /
Trigger created
SQL> --插入数据
SQL> insert into a(name) values('aa');
1 row inserted
SQL> insert into a(name) values('bb');
1 row inserted
SQL> --查询数据
SQL> select * from a;
ID NAME
---------- --------------------
1 aa
2 bb
SQL>
insert语句中sequence的使用方法