insert into table1 values(sequence_name.nextval,'other'....);
第一种方案: 先建一个序列tt: (1)create sequence tt increment by 1 start with 1; 然后,当向表中插入数据时,SQL语句写法如下: (2)insert into tablename values(tt.nextval,'dd','dfdsf'); 第二中方案: 先建一个序列,然后再用触发器。 create sequence tt increment by 1 start with 1; 触发器: create or replace trigger TRG as after insert on tablename for each row begin select tt.nextval into :new.id from dual;--id为自动加1的列 end; 你试试了,看怎么样。
先建一个序列tt:
(1)create sequence tt increment by 1 start with 1;
然后,当向表中插入数据时,SQL语句写法如下:
(2)insert into tablename values(tt.nextval,'dd','dfdsf');
第二中方案:
先建一个序列,然后再用触发器。
create sequence tt increment by 1 start with 1;
触发器:
create or replace trigger TRG as
after insert on tablename
for each row
begin
select tt.nextval
into :new.id from dual;--id为自动加1的列
end;
你试试了,看怎么样。