Auto-increment column in Oracle

Step 1: Create a new test table as follows:

Create Table king
(
ID number (10 ),
Name nvarchar2 (2000)
)

Step 2: Create a sequence
Create sequence king_tb_seq
Minvalue 1
Max value 9999999999
Start with 21
Increment by 1
Cache 20;

Step 3: Create a trigger

Create or replace trigger king_tb_tri
Before insert on King
For each row
Begin
Select king_tb_seq.nextval into: New. ID from dual;
End;

Step 4: perform a test under PL/SQL

SQL test statement:

Insert into King (name) values ('andy Lau ');

Stored Procedure test:

Create or replace procedure insertking
(
K_name varchar2
)
Is
Begin
Insert into King (name) values (k_name );
Commit;
End;

Test:

Begin

Insertking ('andy Lau ');

End;