ITeye博客

lzq478809869的博客

lzq478809869 · 共 1 篇文章

用PrepareStatement对象在sql语句 的insert中怎样实现id的自增长,我的代码如下可是有错误 请指教 谢谢

create or replace trigger S_INTERVIEW_ID before insert on INTERVIEW_INFO referencing old as old new as new for each row begin new.INTERVIEW_ID=S_INTERVIEW_ID.nextval; end; sql .append("insert into INTERVIEW_INFO ( INTERVIEW_ID,INTERVIEWEE_NAME, INTERVIEWEE_SEX,"); sql .append("INTERVIEWEE_POSITION,…

2011-10-25 18:55 · oracle · 评论(0)