oracel设置自增ID

 create sequence SEQ_CSMSCLIENTLOGININFO
 minvalue 1       
 nomaxvalue         
 start with 1       
 increment by 1     
 nocycle            
 nocache;     

 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;