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.