[Oracle] sequence 생성 (시퀀스생성)

 
CREATE SEQUENCE //테이블 시퀀스값
INCREMENT BY 1  // 1씩증가
START WITH 1;  // 1
 
 
CREATE SEQUENCE bidx_b_seq
INCREMENT BY 1
START WITH 1;
 

 

 

INSERT INTO B_BOARD(bidx,originbidx,depth,level_,subject,content,writer,ip,midx)values(bidx_b_seq.NEXTVAL,bidx_b_seq.NEXTVAL,0,0,작성,내용2,김또강t,3,3);