기존(310)/🏀DataBase
[Oracle] sequence 생성 (시퀀스생성)
조각남자
2022. 7. 21. 00:02
|
1
2
3
4
5
6
7
8
9
10
|
CREATE SEQUENCE //테이블 시퀀스값
INCREMENT BY 1 // 1씩증가
START WITH 1; // 1
CREATE SEQUENCE bidx_b_seq
INCREMENT BY 1
START WITH 1;
|
cs |
|
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);
|
cs |