oracle--trigger + sequence implementation self-increment

1 Create Tabletest_table (2Id Number PRIMARY KEY,3NAMEVARCHAR2(Ten),4NicknameVARCHAR2(Ten)5 )6 7 Createsequence Seq_test_trigger8MinValue19MaxValue999999999999999999999999999TenStart with 1 OneIncrement by 1; A  - Create TriggerTest_trigger -BeforeInsert  ontest_table the     forEach row -  when(new.id is NULL) - begin -     SelectSeq_test_trigger.nextval +      into: New.id -      fromdual; + End; A  at  - Create Triggertri_test_id -BeforeInsert  onTest_table--S_depart is the table name -    forEach row - Declare -NextID Number; in begin -   IF: new.id is NULL or: new.id=0  Then --Departid is a column name to     SelectSeq_test_trigger.nextval--S_s_depart is exactly what you just created. +      intoNextID -      fromdual; the: new.id:=NextID; *   End if; $ End;

Two create trigger modes, once created, you can insert data

oracle--trigger + sequence implementation self-increment