oracle - 使用触发器创建自增列

Create Or Replace Trigger "TRIGER"
Before Insert  On <table_name>  Referencing Old As Old New As New  For Each Row 
Begin
Select SEQ.Nextval Into :new.ID From DUAL;
End;
posted @ 2012-11-09 08:51  醇酒醉影  阅读(182)  评论(0编辑  收藏  举报