oracle中，如何插入通过序列查询出来的值，作为id？

Question

``SELECT SEQ_COMPLAINT_BOOK.NEXTVAL AS id FROM DUAL;
insert into COMPLAINT_BOOK_reject values (id,'1','1','1')``

这样的话报错：列在此处不被允许

Answer 1

declare 
  id int;
begin
  SELECT SEQ_COMPLAINT_BOOK.NEXTVAL into id FROM DUAL;
  insert into COMPLAINT_BOOK_reject values (&id,'1','1','1');
end;

没有oracle,没有测过
更简单的是直接用：

  insert into COMPLAINT_BOOK_reject values (SEQ_COMPLAINT_BOOK.NEXTVAL ,'1','1','1');