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
1. create table board(unq number(5) not null,title varchar2(30) not null,pwd varchar2(30) not null,writer varchar2(30) not null,content varchar2(200),hit number(5));rdate timestamp); 2. insert into board values('1','aaa','1234','aaa1','sodan','',sysdate); 3. select *from board order by rdate desc;4.select *from board where title like '%a2%' or content like '%a2%'; 5.select *from board where to_c..
2015. 9. 24.