Auto-increment of oracle trigger + sequence id

1. select * from s_hrdata
2. create Sequence: create sequence s_hrdata_SEQUENCE start with 1 increment by 1
3. CREATE Trigger: create or replace trigger s_hrdata_trgger before insert or update of id on s_hrdata for each row begin select s_hrdata_SEQUENCE.NEXTVAL INTO: NEW. id from dual; END; no id is required when inserting data. Insert into s_hrdata (c_xm, c_xb, c_sfzh, c_ygbh, c_qdbm, c_ssjg, c_sgid, c_zwgw, c_zzzt, c_rzsj, c_tbsj, struct) values ('liangjm ', 'M ', '123', 'ab005618', 'df ', 'sddd', 'cc', 'dd', 1, sysdate, sysdate, 'ter '); select * from s_hrdata author ljm1227134894