We often use an ID automatically assigned by the system as our primary key when designing a database, but there is no such function in ORACLE. We
can implement the function of automatically adding IDs by taking the following functions
1. First create sequence
create sequence seqmax increment by 1
2. Use the method
select seqmax.nextval ID from dual
to get an ID
If you put this statement in the trigger, You can achieve the same function as ms sql's automatic ID increase!