Oracle database table implements PRIMARY key auto-increment function

about Oracle in - sequence sequence+ trigger trigger: Implementing a data Table tabdata_live_cycle The self-increment of the primary key ID in the .

CREATE SEQUENCE Tabdata_live_cycle_seq
MINVALUE 0
MAXVALUE 9999999999999999999999999999
INCREMENT by 1
START with 1
CACHE 20
Noorder
Nocycle;

CREATE OR REPLACE TRIGGER Tabdata_live_cycle_seq_id_art
Before insert on Tabdata_live_cycle
For each row
Begin
Select Tabdata_live_cycle_seq.nextval into:new.id from dual;
End;
/

Oracle database table implements PRIMARY key auto-increment function