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
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.