create sequence seq_users;//创建一个序列 commit; create or replace trigger tr_users //创建触发器 before insert on users for each row begin select seq_users.nextval into :new.id from dual; end; commit;