Add auto increment id in one table

alter table tm_user add primary key (m_id);

drop sequence a_sequence;
create sequence a_sequence
start with 1
increment by 1;


create or replace trigger t_trg
before insert or update on tm_user
for each row
begin
select a_sequence.nextval into :new.m_id from dual;
end;
/