--语法:
--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;