oracle sql
2. 서브 게시판 테이블 (1) 테이블 생성(고유번호,한줄내용, 패스워드, 글쓴이,등록일, 본문 고유번호)create table subBoard(unq number(9) not null,pwd varchar2(20) not null,name varchar2(10),comm varchar2(100),rdate timestamp,cUnq number(9)); select unq,title,writer,rdate,(select count(*) from subBoard where cUnq=a.unq) subCnt from (select rownum rm,unq,title, writer,rdate from (select unq,title,writer,rdate from board order by unq desc)..
2015. 9. 25.
oracle sql
create view empVi20 as select empno,ename,deptno from emp where deptno='20'; create view board_subBoard as select unq,title,writer, rdate rn,(select count(*) from subBoard where cUnq=a.unq) subCnt from(select rownum as rn,unq,title,writer,rdate from(select unq,title,writer,rdate from board order by unq desc)) a; ●팬션 예약 시스템 ▶ 요건-회원관리, 예약관리, 방 관리, 결제관리ㅣ, 후기게시판, 공지사항, 메인화면관리 ▶테이블 생성 (1)-회원관리 테이블-예약..
2015. 9. 25.