利用触发器实现主键增长
drop table CAR1 cascade constraints;
/*==============================================================*/
/* Table: CAR1 */
/*==============================================================*/
create table CAR1
(
"pingpan" VARCHAR2(50),
"color" VARCHAR2(50),
"sudu" VARCHAR2(50),
ID INT not null,
constraint PK_CAR1 primary key (ID)
);
-- Create sequence
create sequence SEQ_CAR1
minvalue 1
maxvalue 99999999999999999999
start with 2
increment by 1
nocache;
CREATE OR REPLACE TRIGGER CAR1_Trigger
Before Insert On CAR1
For Each Row
Begin
Select SEQ_CAR1.Nextval Into :New.ID From Dual;
End;