게시판 만들기

BID 순번 / BTITLE 제목 / BDATE 작성일 / BNAME 작성자 / BHIT 조회수 / BCOUNTENT 내용 / BGROUP 댓글 / bGroup 관련있는 글의 그룹 / bStep 관련있는글의 몇번째 위치 / bIndent 들여쓰기 개수

create table MYBOARD(

BID NUMBER(4) PRIMARY KEY,

BTITLE VARCHAR2(200),

BDATE DATE DEFAULT SYSDATE,

BNAME VARCHAR2(100),

BHIT NUMBER(4) DEFAULT 0,

BCONTENT VARCHAR2(3000),

BGROUP NUMBER(4),

BSTEP NUMBER(4),

BINDENT NUMBER(4)

);

CREATE SEQUENCE BOARD_SEQ;

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'쇼핑몰관련예제','홍길동','글 내용입니다.',

    BOARD_SEQ.CURRVAL,0,0);

    

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'체크리스트평가기준','홍길동2','글 내용입니다.',

    BOARD_SEQ.CURRVAL,0,0);

 

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'평가자체크리스트ALL','홍길동3','글 내용입니다2.',

    BOARD_SEQ.CURRVAL,0,0);        

    

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판','홍길동4','글 내용입니다3.',

    BOARD_SEQ.CURRVAL,0,0);        

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판코드','홍길동4','글 내용입니다4.',

    BOARD_SEQ.CURRVAL,0,0);        

COMMIT;

SELECT * FROM MYBOARD;

DELETE MYBOARD;

SELECT * FROM MYBOARD ORDER BY BGROUP DESC, BSTEP ASC;

--게시판코드 댓글넣기

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판코드','홍길동4','글 내용입니다4.',

    11,1,1);

SELECT*FROM MYBOARD ORDER BY BGROUP DESC,BSTEP ASC;

--게시판 댓글 게시판1 넣기

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판1','홍길동4','글 내용입니다4.',

    10,1,1);        

SELECT*FROM MYBOARD ORDER BY BGROUP DESC,BSTEP ASC;

rollback;

--게시판 댓글 게시판 넣기

UPDATE MYBOARD

SET BSTEP = BSTEP+1 WHERE BGROUP=10 AND BSTEP>0;

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판','홍길동4','글 내용입니다4.',

    10,1,1);    

SELECT*FROM MYBOARD ORDER BY BGROUP DESC,BSTEP ASC;

--게시판 댓글 게시판2 넣기

UPDATE MYBOARD

SET BSTEP = BSTEP+1 WHERE BGROUP=10 AND BSTEP>1;

INSERT INTO MYBOARD(

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'게시판2','홍길동4','글 내용입니다4.',

    10,2,2);  

SELECT*FROM MYBOARD ORDER BY BGROUP DESC,BSTEP ASC;

--BID가 8인 게시물에 댓글을 추가하는 쿼리를 작성하시오

UPDATE MYBOARD SET BSTEP=BSTEP+1 WHERE BROOUP=8 AND BSTEP>1;

INSERT INTO MYBOARD (

BID,BTITLE,BNAME,BCONTENT,BGROUP,BSTEP,BINDENT)

VALUES (

BOARD_SEQ.NEXTVAL,'평가자체크리스트ALL','홍길동3','글 내용입니다2.',

    8,1,1);  

SELECT*FROM MYBOARD ORDER BY BGROUP DESC,BSTEP ASC;

DELETE MYBOARD WHERE BGROUP=8;

COMMIT;