Sequence binding trigger in Oracle database for primary key self-growth

First, the data table name is T_office, its primary key is PID (number type)

Second, create a sequence for the PID field of the data table first

Sequence Name: S_t_office_pid

Sequence Details:

Third, create the corresponding trigger

Trigger Name: T_officetriger

Trigger Specific content:

Create or replace
TRIGGER
Hymgs_industry_fq6. T_officetriger
Before INSERT on Hymgs_industry_fq6. T_office for each ROW
BEGIN
Select S_t_office_pid.nextval into:new. PID from dual;
END;

Note: Update the value of the PID primary key before inserting new data

Sequence binding trigger in Oracle database for primary key self-growth