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_char(rdate,'YYYY-mm-dd HH24')='2015-09-10 13';

6.

select *from board where rownum<=5 order by unq desc;

select * from(select rownum rm,title, writer, content,rdate from (select * from board order by unq desc)) where rm between 6 and 10;

7.

update board set title='자바' where unq='3';