Oracle Build table, build primary key, self-increment

Oracle Build table, build primary key, self-increment

--Build a table

CREATE TABLE Test (

ID Number (4) Not null primary key,

Name VARCHAR2 (25)

)

--Sequence

Create sequence Test_sequence

Increment by for each increase of several

Start with 1-counting starting from 1

MinValue 1

Nomaxvalue--Do not set the maximum value

Nocycle--keep accumulating, not looping

NoCache--Do not build buffers

--Trigger

Create Trigger Test_tiger before

Insert on Test for each row if (New.id is null)

Begin

Select Test_sequence.nextval into:new.id from dual;

End

--Test

Insert into Test (name) VALUES (' Zhangsan ');

Self-increment the ID for data in an existing table

Create sequence seq_a_id

MinValue 1

Nomaxvalue

Start with 1

Increment by 1

NoCache

Update sys_menu_dict Set menu_id = Seq_a_id.nextval

Oracle Build table, build primary key, self-increment