10.05.26 DB 실습

Study/Oracle 2011. 9. 3. 23:56
/*
insert
into student(sno, sname, year, dept)
values (20063703,'서정회',3,'멀티');

insert
into enrol(sno,cno,grade,midterm,final)
values(20063703,'c413','A',99,99);
*/

select sname, s.dept
from student s, enrol e, course c
where s.sno=e.sno and e.cno=c.cno and c.prname='우영운'

select sname, s.dept
from student s, enrol e, course c
where s.sno=e.sno and e.cno=c.cno and c.cname='자료구조';

select cno, count(*) as 수강인원
from enrol
group by cno;

select cno, count(*) as 수강인원
from enrol
group by cno
having count(*) >= 3

update student
set year=2
where sno=20063703;

update enrol
set grade='F',  midterm = midterm - 20, final = final - 20
where sno=20063703 and cno='c413';

select lnr
from loan
where bnm = 'perryridge' and amount > 1200;

'Study > Oracle' 카테고리의 다른 글

기말고사 문제  (0) 2011.09.04
10.06.10 DB 실습  (0) 2011.09.03
10.05.04 DB 실습  (0) 2011.09.03
10.04.28 DB 실습  (0) 2011.09.03
10.06.08 DB 수업  (0) 2011.09.03
Posted by 코딩하는 야구쟁이
,