Create a growth generator in oracle Region

SQL generation

-- 1. Create a table in tables
Create table tb_users
(
Id number (4 ),
UserName varchar2 (20 ),
Password varchar2 (20)
)
-- 2. Sequence Creation
Create sequence sq_user
Start with 1
Increment by 1
-- 3. producer
Create or replace trigger tri_tb_users
Before insert on tb_users
For each row
Begin
Select sq_user.nextval into: new. id from dual;
End;
-- 4. Add a data volume
Begin
Insert into tb_users (username, password) values ('xiachufeng', 'xiachufeng ');
Insert into tb_users (username, password) values ('kevin ', 'kevin ');
Commit;
End;
-- 5. Check the incremental data and find that the id column is incremented.
Select * from tb_users