[工作]sequence trigger

create sequence CBClaimQuestionTrace_SEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

CREATE OR REPLACE TRIGGER CBClaimQuestionTrace_TRIGGER
  BEFORE INSERT ON CallBackClaimQuestionTrace
  FOR EACH ROW
BEGIN
  SELECT CBClaimQuestionTrace_SEQUENCE.NEXTVAL INTO :new.TraceID FROM DUAL;
END;

 

 select   *   from   user_sequences order by sequence_name 但是怎么判断sequence有没有和表对应起来？

 

得写个程序判断一下 自己手动操作对不对了：hbm.xml中的主键策略对不对，实体类对不对？