楼上不看题,楼主sequence已经建了
:new.cid不可以被赋值
你是想在insert 时再更新这个序列,不是兜圈子么,在insert groupon_cus_info时直接把SEQ_CID.nextval赋给cid就可以了
[/quote]
我这个刚刚接触,不是很明白。Oracl数据库中表名groupon_cus_info,其主键名是cid,类型number(10,0)
sequence语句
CREATE SEQUENCE "GROUPON"."SEQ_CID" MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ;
触发器语句
CREATE OR REPLACE
TRIGGER TR_GROUPON_CUS_INFO
BEFORE INSERT ON "groupon_cus_info"
for each row
BEGIN
select SEQ_CID.nextval into :new.cid from dual;
END;
这样报错如一开始的图
楼上不看题,楼主sequence已经建了
:new.cid不可以被赋值
你是想在insert 时再更新这个序列,不是兜圈子么,在insert groupon_cus_info时直接把SEQ_CID.nextval赋给cid就可以了
[/quote]
我这个刚刚接触,不是很明白。Oracl数据库中表名groupon_cus_info,其主键名是cid,类型number(10,0)
sequence语句
CREATE SEQUENCE "GROUPON"."SEQ_CID" MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ;
触发器语句
CREATE OR REPLACE
TRIGGER TR_GROUPON_CUS_INFO
BEFORE INSERT ON "groupon_cus_info"
for each row
BEGIN
select SEQ_CID.nextval into :new.cid from dual;
END;
这样报错如一开始的图