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;