现在插入时统统对seq_id字段插入-1,然后编写如下触发器得解。 create or replace trigger new_seq_id before insert on inv_material_card_query for each row declare t_count inv_material_card_query.seq_id%TYPE; begin select (nvl(max(seq_id),0)+1)into t_count from inv_material_card_query; :new.seq_id:=t_count; end; --inv_material_card_query为一个表名,
create or replace trigger new_seq_id
before insert on inv_material_card_query
for each row
declare
t_count inv_material_card_query.seq_id%TYPE;
begin
select (nvl(max(seq_id),0)+1)into t_count from inv_material_card_query;
:new.seq_id:=t_count;
end; --inv_material_card_query为一个表名,