작성
·
298
0
oracle에서 tb_board 생성 아래처럼 했습니다. 혹 수정사항 있는지 확인 부탁드려요.
create table tb_board(
idx number primary key,
title varchar2(100) not null,
contents varchar2(4000) not null,
count number,
writer varchar2(30) not null,
indate date not null
)
create sequence num_seq start with 1 increment by 1 maxvalue 9999 cycle nocache;
insert into tb_board(idx,title,contents,count,writer,indate)
values(num_seq.nextval,'게시판만들기','게시판 만들기',0,'관리자',sysdate)