Create sequence seq_Fm; --建一个序列CREATE Or Replace TRIGGER Trig_Fm BEFORE INSERT --建一触发器
ON Fm --Fm为表名
FOR EAcH ROW
Declare Begin
Select Seq_Fm.NextVal Into :New.Id From dual;
--~~~~~~为序列名称 ~~~~你所谓的ID
End Trig_Fm;
/
ON Fm --Fm为表名
FOR EAcH ROW
Declare Begin
Select Seq_Fm.NextVal Into :New.Id From dual;
--~~~~~~为序列名称 ~~~~你所谓的ID
End Trig_Fm;
/
insert into tablename (id) values (tablename_seq.nextvale)