创建了一个表,和触发器,但是有问题,那位帮忙查下:
CREATE TABLE "SCOTT"."ADVRECORD"
( "ADVRECORDID" NUMBER NOT NULL ENABLE,
"ADVBRANCHID" NUMBER NOT NULL ENABLE,
"ADVMEDIANAME" VARCHAR2(30 CHAR) NOT NULL ENABLE,
"ADVSTARTTIME" DATE NOT NULL ENABLE,
"ADVENDTIME" DATE NOT NULL ENABLE,
"ADVCONTENT" VARCHAR2(2000 CHAR) NOT NULL ENABLE,
"IFDELETE" NUMBER DEFAULT 0 NOT NULL ENABLE,
"SUBMITTIME" TIMESTAMP (6) NOT NULL ENABLE,
CONSTRAINT "ADVRECORD_PK" PRIMARY KEY ("ADVRECORDID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."ADVRECORDID" IS '广告ID, 自增字段';
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."ADVBRANCHID" IS '广告所在中心ID';
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."ADVMEDIANAME" IS '广告媒体名称';
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."ADVENDTIME" IS '广告结束时间';
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."ADVCONTENT" IS '广告内容';
COMMENT ON COLUMN "SCOTT"."ADVRECORD"."SUBMITTIME" IS '提交时间';
CREATE OR REPLACE TRIGGER "SCOTT"."ADVRECORD_TRG"
BEFORE INSERT ON SCOTT.ADVRECORD
FOR EACH ROW
BEGIN
SELECT ADVRECORDSEQUENCE.NEXTVAL INTO :NEW.ADVRECORDID FROM DUAL;
END;
/
ALTER TRIGGER "SCOTT"."ADVRECORD_TRG" ENABLE;
---
说明:oracle 版本是 10g,登录的用户是 scott,
执行后的log 是 :
表已创建。
注释已创建。
注释已创建。
注释已创建。
注释已创建。
注释已创建。
注释已创建。
警告: 创建的触发器带有编译错误。
触发器已更改
为什么:有警告 警告: 创建的触发器带有编译错误。???
我的用户已锁定,从这里弄下, 好心人看到了, 帮帮忙