정다운_테이블 만들고, PK, FK 설정한 후 데이터를 insert하고 inner join과 outer join을 한 문제 제출합니다!

[정다운]

--1번

create table colleage

(

  C_code varchar2(40)

, c_name varchar2(40)

);

--3번

alter table colleage

add(

constraint pk_colleage primary key (c_code)

);

--2번, 4번

create table hakgwa

(

  h_code varchar2(40)

, h_name varchar2(40)

, h_col_code varchar2(40)

, constraint pk_hakgwa primary key(h_code)

,constraint fr_h_code foreign key (h_col_code) references colleage(c_code)

);

--5번

insert into colleage(c_code, c_name)

                    values ('w01', '솔아시아매니지먼트');

insert into colleage(c_code, c_name)

                    values ('w02', '외식조리');

insert into colleage(c_code, c_name)

                    values ('w03', '철도물류');                    

insert into colleage(c_code, c_name)

                    values ('w04', '디지털미디어');

insert into colleage(c_code, c_name)

                    values ('w05', '보건복지');

--6번

insert into hakgwa(h_code, h_name, h_col_code)

                    values('h001', '외식조리학과', 'w02');

insert into hakgwa(h_code, h_name, h_col_code)

                    values('h002', '호텔관광경영학과', 'w02');                    

insert into hakgwa(h_code, h_name, h_col_code)

                    values('h003', '철도경영학과', 'w03');                    

insert into hakgwa(h_code, h_name, h_col_code)

                    values('h004', '간호학과', 'w05');   

--7번

select *

from colleage inner join hakgwa on c_code = h_col_code;

select *

from colleage, hakgwa

where c_code = h_col_code;

--8번

select *

from colleage full outer join hakgwa on c_code = h_col_code;

select *

from colleage, hakgwa

where c_code(+) = h_col_code

union

select *

from colleage, hakgwa

where c_code = h_col_code(+);

제출_151119.sql

[정다운]

와! 대단해요!