The ID of an Oracle table is automatically added when the Oracle table is created.

 

Exec pro_create ('lt _ oa_sms ', 'smsid '); First, perform the first step:

Create sequence auto_add -- sequence name (auto_add is a series name, just name it)
Increment by 1 -- increase by 1 each time
Start with 1 -- start from 1
Nomaxvalue -- no maximum value
Nocache -- no cache Sequence

 

Next, perform Step 2:

Create or replace trigger trg_lt_commenduser/* ---- (myproject) trigger name ----*/
Before insert on lt_commenduser/* ---- (project_manage) Table Name ----*/
For each row
Begin
If (: New. commendid is null) Then/* ---- (productionid) column name ----*/
Select auto_add.nextval into: New. commendid from dual;/* ---- (auto_add) sequence name ---- * // * ---- (productionid) column name ----*/
End if;
End;

This is the auto-increment method of Oracle keys.