oracle id自增

-- Create table T_TX_EXCEPTION
--DROP TABLE T_TX_EXCEPTION;
create table T_TX_EXCEPTION
(
    id NUMBER(20) NOT NULL,
  group_id VARCHAR2(64 BYTE),
  unit_id VARCHAR2(32 BYTE),
  mod_id VARCHAR2(128 BYTE),
  transaction_state NUMBER(4,0),
  registrar NUMBER(4,0),
  ex_state NUMBER(4,0),
  remark VARCHAR2(1024 BYTE),
  create_time DATE
);

alter table T_TX_EXCEPTION
  add primary key (id);

---自增序列
--DROP SEQUENCE T_TX_EXCEPTION_SEQ;
CREATE SEQUENCE T_TX_EXCEPTION_SEQ
MINVALUE 1 
NOMAXVALUE 
INCREMENT BY 1 
START WITH 1 NOCACHE ;

--创建触发器
-- DROP TRIGGER T_TX_EXCEPTION_id_TRIGGER;
create or replace trigger T_TX_EXCEPTION_id_TRIGGER
  before insert on T_TX_EXCEPTION  
  for each row
begin
  select T_TX_EXCEPTION_SEQ.nextval into :new.id from dual;
end T_TX_EXCEPTION_id_TRIGGER;

-- INSERT data
insert into T_TX_EXCEPTION(group_id,unit_id) values('sha','shao') ;
   commit ;
   
--SELECT
SELECT * from T_TX_EXCEPTION;