SQL> create table a (a number,b char(10));Table created.SQL> create sequence t start with 1;Sequence created.SQL> insert into a values(t.nextval,'sss');1 row created.SQL> insert into a values(t.nextval,'ddd');1 row created.SQL> insert into a values(t.nextval,'fff');1 row created.SQL> commit;Commit complete.SQL> select * from a; A B
---------- ----------
1 sss
2 ddd
3 fffSQL>
---------- ----------
1 sss
2 ddd
3 fffSQL>
create sequence your_seq
nocycle
maxvalue 9999999999
start with 1;2.使用触发器实现自增:
create or replace trigger your_seq_tri
before insert on your_table1 for each row
declare
next_id number;
begin
select your_seq.nextval into next_id from dual;
:new.id := next_id;
end;