세로로 조회되는 자료를 가로 한 행으로 출력

1. WM_CONCAT()

SELECT WM_CONCAT(A.ENAME) AS NAME_LIST
  FROM SCOTT.EMP A
 WHERE A.DEPTNO = '30'

 

2. SYS_CONNECT_BY_PATH()

SELECT LPAD(' ',2*LEVEL-1) || SYS_CONNECT_BY_PATH(ENAME, '/') AS "Path"
  FROM SCOTT.EMP
CONNECT BY PRIOR MGR=EMPNO
 START WITH EMPNO='7934'