-- Create sequence 工行订单号 -- drop sequence cmbc_cap_sequence; create sequence cmbc_cap_sequence minvalue 1 maxvalue 99999999 start with 00000001 increment by 1 cache 100 cycle;