oracle test 및 답
1.INSERT INOT pReserve (unq,id,sDate,eDate,mCnt,rNum,app,rDate)VALUES('4','test4','2015-09-25','2015-09-27','2','3','N',sysdate); 2.서울에 사는 남자 회원 출력select * from pMember where addr like '%서울%' and gender='M'; 3.가장 최근에 등록한 회원 1명 출력(rownum적용)select id, name from (select id,name from pMember order by unq desc)where rownumto_char(sysdate,'YYYY/MM/DD'); 6.mlastInfo라는 컬럼명으로 출력(오늘 포함 숙박이 지난 회원 출력)select..
2015. 9. 29.
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.