insert into test1(id, name) values ((select id_test.nextval from dual), 'runto30');
plsql中以上语句执行报:ORA-02287:此处不允许序号(sequence number not allowed here) 的避免以及强制实现
以下是可行的:
insert into test1(id, name) select id_test.nextval, 'runto30' from dual;
insert into test1(id, name) values(id_test.nextval,'123');