신문과 프로그래머.

[오라클] 스칼라서브쿼리에서 컬렉션(Multirow) 사용

참고 URL = http://scidb.tistory.com/69
아래 순서대로 하면 됩니다.

create or replace type dept_type as object
(
     dept_cd  char(10),
     dept_nm name varchar2(50)
);

create or replace type array_dept as varray(100) of dept_type;

select *
from (
select  a.id
                      ,a.name
                      ,cast(multiset (select  dept_cd
                                                      dept_nm
                                            from dept b
                                            where b.dept_cd = a.dept_cd
                                           ) as array_dept
                           ) as dept_info
            from member a
  );

사람인긱이 런칭되었네요.

프리랜서로 활동할 무대가 넓어졌습니다.

http://saram.in/s/gig_launch