一)建立序列:
create sequence SMSLOG_SEQ2
minvalue 1
maxvalue 999999999999999999
start with 601
increment by 1
cache 20;
二)建立触发器:
CREATE OR REPLACE TRIGGER "smslog_trig3"
BEFORE INSERT ON smslog
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
DECLARE
BEGIN
SELECT smslog_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END smslog_trig;
三)建立表:
create table SMSLOG2
(
ID NUMBER not null,
USERID NUMBER,
USERNAME VARCHAR2(200),
DEPTID NUMBER
)