게시판 스키마
CREATE TABLE board (
no NUMBER PRIMARY KEY,
title VARCHAR2(300) NOT NULL,
content VARCHAR2(2000) NOT NULL,
writer VARCHAR2(30) NOT NULL,
writeDate DATE DEFAULT sysdate,
hit NUMBER DEFAULT 0,
pw VARCHAR2(20) NOT NULL
);
CREATE SEQUENCE board_seq;
게시판운영쿼리
SELECT no, title, writer, writeDate, hit
FROM board
ORDER BY no DESC;
SELECT no, title, content, writer, writeDate, hit
FROM board
WHERE no = 2;
UPDATE board SET hit = hit + 1
WHERE no = 2;
COMMIT;
INSERT INTO board(no, title, content, writer, pw)
VALUES (board_seq.nextval, '게시판', '좋은 글을 공유 합니다.', '정다희', '1111');
COMMIT;
UPDATE board SET title ='게시판입니다.', content='게시판 완성', writer='개발자'
WHERE no = 2 AND pw = '1111';
COMMIT;
DELETE FROM board
WHERE no = 2 AND pw = '1111';
ROLLBACK;
UPDATE board SET pw = '2222'
WHERE no=2 AND pw ='1111';
ROLLBACK;