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)