/*创建序列*/
CREATE SEQUENCE seq_qsp_topic INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER ;
CREATE OR REPLACE TRIGGER trg_qsp /*触发器*/
BEFORE INSERT ON Qsp
FOR EACH ROW
BEGIN
select seq_qsp.NEXTVAL INTO :NEW.QSPNO FROM DUAL;
END;
/*问卷表*/
create table Qsp
(
QspNO integer primary key,
QName varchar2(50) null,
QDescription varchar2(100) null ,
QFDate date null,
QBeginDate date null,
QEndDate date null,
QXDate date null,
QStatu number(2) default '0' not null,
QImgUrl varchar2(100) null,
Qtype varchar2(20) null
);
oracle创建序列自增
最新推荐文章于 2023-11-07 16:56:18 发布