[오라클] 세로열을 가로로 콤마 붙여서 출력.

SQL/Oracle

[오라클] 세로열을 가로로 콤마 붙여서 출력.

tornado 2014. 10. 15. 13:58

[원문] http://psoug.org/reference/undocumented.html

CREATE TABLE t (
col1 VARCHAR2(5),
col2 VARCHAR2(20));

INSERT INTO t VALUES (111, 'This');
INSERT INTO t VALUES (111, 'is');
INSERT INTO t VALUES (111, 'a');
INSERT INTO t VALUES (111, 'test');
INSERT INTO t VALUES (222, 'This is not');

SELECT * FROM t;

col concat format a40

SELECT col1, wmsys.wm_concat(col2) CONCAT
FROM t
GROUP BY col1;

SELECT col1, TRANSLATE(wmsys.wm_concat(col2), 'A,', 'A ') CONCAT
FROM t

GROUP BY col1;