--语法：

--1.设置SEQ

create sequence SEQ_CSMSCLIENTLOGININFO

minvalue 1        nomaxvalue          start with 1        increment by 1      nocycle             nocache;     

 

--2.设置TG

CREATE OR REPLACE TRIGGER TG_CSMSCLIENTLOGININFO

BEFORE INSERT ON CSMS_CLIENT_LOGIN_INFO FOR EACH ROW WHEN (new.id is null) begin select SEQ_CSMSCLIENTLOGININFO.nextval into:new.id from dual; end;