February 21, 2017 Oracle database, how to set the self-increment of the primary key in the table

1. Create a new table, set the ID as the primary key

For example, the table name created is: Uf_receive_pay

2. Set the ID of the primary key self-increment, through the sequence implementation

Create sequence

CREATE SEQUENCE Uf_receive_pay_seq
INCREMENT by 1--add a few each time
Start with 1-counting starting from 1
Nomaxvalue--Do not set the maximum value
Nocycle--keep accumulating, not looping
CACHE 10;

3. Create a Trigger

CREATE TRIGGER Uf_receive_pay before
Insert on uf_receive_pay for each ROW
Begin
Select Uf_receive_pay_seq.nextval into:new. ID from dual;
End

4. Submit

Commit

/

February 21, 2017 Oracle database, how to set the self-increment of the primary key in the table