Oracle uses relevant triggers to implement auto-incremental ID

The following article describes how to use relevant triggers to implement auto-increment IDs in Oracle. The actual steps for implementing auto-increment effects for IDs in the userinfo table are as follows, if you are interested in the actual operation steps, the following article will further increase your interest in tb. 1. create a sequence code -- create sequence Create sequence seq_userinfo minvalue 1 www.2cto.com start with 1 increment by 1; 2. create trigger code create or replace trigger tigger_userinfo before insert on userinfo for each row declare begin select SEQ_userinfo.nextval into: New. id from dual; end tigger_userinfo; prepared by tbwshc