SQL>?select?deptno?,wm_concat(ename)from?emp?group?by?deptno;

????DEPTNO
----------
WM_CONCAT(ENAME)
--------------------------------------------------------------------------------
????????10
CLARK,MILLER,KING

????????20
SMITH,FORD,ADAMS,SCOTT,JONES

????????30
ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD


SQL>?ed
已寫入?file?afiedt.buf

??1*?select?deptno?部門號?,wm_concat(ename)?部門中員工的姓名from?emp?group?by?deptno
SQL>?/
select?deptno?部門號?,wm_concat(ename)?部門中員工的姓名from?emp?group?by?deptno
????????????????????????????????????????????????????????????*
第?1?行出現錯誤:
ORA-00923:?未找到要求的?FROM?關鍵字


SQL>
SQL>?ed
已寫入?file?afiedt.buf

??1*?select?deptno?部門號?,wm_concat(ename)?部門中員工的姓名from?emp?group?by?deptno
SQL>?select?deptno?,wm_concat(ename)from?emp?group?by?deptno;

????DEPTNO
----------
WM_CONCAT(ENAME)
--------------------------------------------------------------------------------
????????10
CLARK,MILLER,KING

????????20
SMITH,FORD,ADAMS,SCOTT,JONES

????????30
ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD


SQL>?ed
已寫入?file?afiedt.buf

??1*?select?deptno部門號?,wm_concat(ename)部門中員工的姓名?from?emp?group?by?deptno
SQL>?/
select?deptno部門號?,wm_concat(ename)部門中員工的姓名?from?emp?group?by?deptno
???????*
第?1?行出現錯誤:
ORA-00904:?"DEPTNO部門號":?標識符無效


SQL>?select?deptno?,wm_concat(ename)from?emp?group?by?deptno;

????DEPTNO
----------
WM_CONCAT(ENAME)
--------------------------------------------------------------------------------
????????10
CLARK,MILLER,KING

????????20
SMITH,FORD,ADAMS,SCOTT,JONES

????????30
ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD


SQL>?ed
已寫入?file?afiedt.buf

??1*?select?deptno?部門號,wm_concat(ename)?部門中員工的姓名?from?emp?group?by?deptno
SQL>?/

????部門號
----------
部門中員工的姓名
--------------------------------------------------------------------------------
????????10
CLARK,MILLER,KING

????????20
SMITH,FORD,ADAMS,SCOTT,JONES

????????30
ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD


SQL>?set?linesize?200
SQL>?col?部門中員工的姓名?for?a60
SQL>?select?deptno?部門號，wm_concat(ename)?部門中的員工姓名?from?emp?group?by?deptno;

????部門號
----------
部門中的員工姓名
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------

????????10
CLARK,MILLER,KING

????????20
SMITH,FORD,ADAMS,SCOTT,JONES

????????30
ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD


SQL>