Oracle Auto-incremental ID implementation, Oracle incremental ID implementation
First, create a table:
Create table test (id number (32) not null primary key, name varchar2 (32 ));
Then, customize a sequence)
Create sequence test_sequenceINCREMENT BY 1 -- add several start with 1 each time -- count NOMAXVALUE from 1 -- do not set the maximum value NOCYCLE -- accumulate all the time, do not cycle NOCACHE -- do not CREATE a buffer
You also need to create a trigger)
Create trigger test_trigger before insert on test for each row when (new. id is null) -- starts the trigger to generate the idnumber begin select test_sequence.nextval into: new. id from sys. dual; end;
Insert Test Data
Insert into test (name) values ('hangsan'); insert into test (id, name) values (101, 'lisi ');
Result:
PS: When a trigger is created, ":" In into: new. id from sys. dual is near new, not into: new. id from sys. dual.
Author: itmyhome