ORACLE 게시판 기본 활용 sql query

오라클 게시판 기본 활용 쿼리

 

-list <게시판 리스트 출력>
selct no, title, writer, writedate,hit

from board order by no desc

-view <2번 게시물 조회>
select no, title, content, writer, writedate, hit

from board where no=2

-write <글작성>

insert into board(no, title, content, writer)

values (board_seq.nextval, '제목'. '내용', '작성자')

-update <글수정>

update board set title='제목' , content='내용', writer='작성자' where no=2

-delete <글삭제>
delete from board where no=2