CREATE SEQUENCE SINTUID INCREMENT BY 1 START
WITH 1 MAXVALUE 1.0E10 MINVALUE 1
NOCYCLE CACHE 20 NOORDER;
CREATE TRIGGER TRGINTUID4 BEFORE INSERT ON "SCOTT"."T_USERS"
FOR EACH ROW
begin
select SINTUID.nextval
into :new.INTUID
form dual;
end TRGINTUID4;
警告: 创建的触发器带有编译错误。怎么样解决以上问题?谢谢
WITH 1 MAXVALUE 1.0E10 MINVALUE 1
NOCYCLE CACHE 20 NOORDER;
CREATE TRIGGER TRGINTUID4 BEFORE INSERT ON "SCOTT"."T_USERS"
FOR EACH ROW
begin
select SINTUID.nextval
into :new.INTUID
form dual;
end TRGINTUID4;
警告: 创建的触发器带有编译错误。怎么样解决以上问题?谢谢
FOR EACH ROW
begin
if inserting then
insert into test values(SINTUID.nextval,....)
end TRGINTUID4;
if inserting then
insert into test values(SINTUID.nextval,....)
我看不懂的。我刚接触oracle不久,希望能说得详细点。万分感谢
插入insert into test values(SINTUID.nextval,....)
执行这条语句。
CREATE TRIGGER TRGINTUID4 BEFORE INSERT ON "SCOTT"."T_USERS"
FOR EACH ROW
begin
select SINTUID.nextval
into :new.INTUID
form dual;
end TRGINTUID4;