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

[원문] 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;