oracle sql
insert into pMember values('1','test1','1111','홍길동','010-2333-0100','서울','M');insert into pMember values('2','test2','1111','김민수','010-2333-3333','부산','M');insert into pMember values('3','test3','1111','박찬호','010-2314-0100','서울','M');insert into pMember values('4','test4','1114','이영희','010-2333-0100','대구','F');insert into pMember values('5','test5','1115','이진아','010-2551-5120','서울','F'); insert ..
2015. 9. 27.
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.