首先建立一个 create sequence SEQ_y minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20; 然后调用的时候用 seq_y.Nextval 就可以了
DROP SEQUENCE TEST.SEQ_STUDENT_ID;CREATE SEQUENCE SEQ_STUDENT_ID START WITH 5 MAXVALUE 1E27 MINVALUE 0 NOCYCLE NOCACHE NOORDER;CREATE TABLE STUDENT_INFO ( ID NUMBER NOT NULL, NAME VARCHAR2(50 BYTE), SEX VARCHAR2(10 BYTE), AGE NUMBER, BIRTHDAY DATE, PHONE VARCHAR2(20 BYTE) ) CREATE OR REPLACE TRIGGER TG_STUDENT_INFO BEFORE INSERT ON STUDENT_INFO REFERENCING OLD AS old NEW AS new FOR EACH ROW BEGIN IF :new.ID IS NULL THEN SELECT SEQ_STUDENT_ID.NEXTVAL INTO :new.ID FROM dual; END IF; END;
create sequence SEQ_y
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
然后调用的时候用 seq_y.Nextval
就可以了
DROP SEQUENCE TEST.SEQ_STUDENT_ID;CREATE SEQUENCE SEQ_STUDENT_ID
START WITH 5
MAXVALUE 1E27
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER;CREATE TABLE STUDENT_INFO
(
ID NUMBER NOT NULL,
NAME VARCHAR2(50 BYTE),
SEX VARCHAR2(10 BYTE),
AGE NUMBER,
BIRTHDAY DATE,
PHONE VARCHAR2(20 BYTE)
)
CREATE OR REPLACE TRIGGER TG_STUDENT_INFO
BEFORE INSERT ON STUDENT_INFO
REFERENCING OLD AS old NEW AS new
FOR EACH ROW
BEGIN
IF :new.ID IS NULL THEN
SELECT SEQ_STUDENT_ID.NEXTVAL
INTO :new.ID
FROM dual;
END IF;
END;
我想在jsp中提交数据的时候自动自增,还应该做哪些设置?谢谢。。