Oracle Set Primary key ID self-growth

--Create a sequence:
CREATE SEQUENCE Seq_grelation--use unified prefix to make it easy to manage
INCREMENT by 1-the self-increment step is set here to 1
Start with 1--count start here set to 1
Nomaxvalue--No maximum option is set maxvalue| MINVALUE
Nocycle--keep accumulating, not looping
CACHE 10;


--Create a trigger:
CREATE TRIGGER Grelation_trigger before
Insert on ' guiderelation ' for each ROW
Begin
Select Seq_grelation.nextval Into:New.RELATIONID from dual;
End
Seq_grelation grelation_trigger seq_grelation.nextval new.relationid (corresponding ID name) is to be changed.

Oracle Set Primary key ID self-growth