Oracle region auto-incrementing Region

-- Create a sequence

Create sequence test_sequence2

Increment by 1
Start with 1
Nomaxvalue
Minvalue 1
Nocycle;

-- Create a two-dimensional External table
Create Table test_create_tab2 (
Id int,
Val varchar (10 ),
Primary Key (ID)
);

-- Create a producer. Once other fields are inserted into the producer table, the ID field automatically increases.
Create or replace trigger beforetestcreate2insert
Before insert on test_create_tab2
For each row
Begin
Select test_sequence2.nextval into: New. ID from dual;
End;
/

Insert into test_create_tab2 (VAL) values ('no id2 ');