oracle中有一个表的id是number型自增的 insert时如何不用插入id 只插入其他字段就实现数据的插入

oracle 12c之前必须用sequence : create table test_tab ( id number primary key ); create sequence test_seq start with 1 increment by 1 nocycle; create or replace trigger test_trg before insert on test_tab for each row begin select test