728x90
반응형
셈플테이블은 아래와 같다.
------------------------------------------------------------
SELECT 'AAAA' AS COD, '1111' AS NAM
FROM DUAL
UNION ALL
SELECT 'AAAA' AS COD, 'aaaa' AS NAM
FROM DUAL
UNION ALL
SELECT 'AAAA' AS COD, 'xxxx' AS NAM
FROM DUAL
UNION ALL
SELECT 'AAAA' AS COD, '에이이에' AS NAM
FROM DUAL
UNION ALL
SELECT 'BBBB' AS COD, '일일일' AS NAM
FROM DUAL
UNION ALL
SELECT 'BBBB' AS COD, 'twotwo' AS NAM
FROM DUAL
UNION ALL
SELECT 'BBBB' AS COD, '3333' AS NAM
FROM DUAL
----------------------------------------
다음 결과를 쿼리하시오
COD NAM
AAAA 1111,aaaa,xxxx,에이
BBBB 일일이,twotwo,3333
--111111111
SELECT COD
, WM_CONCAT(DISTINCT NAM)
FROM (SELECT 'AAAA' AS COD, '1111' AS NAM FROM DUAL UNION ALL
SELECT 'AAAA' AS COD, 'aaaa' AS NAM FROM DUAL UNION ALL
SELECT 'AAAA' AS COD, 'xxxx' AS NAM FROM DUAL UNION ALL
SELECT 'AAAA' AS COD, '에이이에' AS NAM FROM DUAL UNION ALL
SELECT 'BBBB' AS COD, '일일일' AS NAM FROM DUAL UNION ALL
SELECT 'BBBB' AS COD, 'twotwo' AS NAM FROM DUAL UNION ALL
SELECT 'BBBB' AS COD, '3333' AS NAM FROM DUAL )
GROUP BY COD
728x90
반응형
'DB-Oracle' 카테고리의 다른 글
ORACLE 세션관리의 기초 (0) | 2022.12.01 |
---|---|
특정문자열 연결DATA를 Row행단위 결과로 작업 (0) | 2022.12.01 |
계층구조 조회쿼리 (0) | 2022.12.01 |
10000줄짜리 임의데이터 쿼리작업 (0) | 2022.12.01 |
oracle CONNECT BY 계층구조 쿼리에 대한 이해 (0) | 2022.12.01 |