oracle wm_concat函数，用于列转行，逗号分隔

?

?

SQL> select 'create or replace view as select '|| wm_concat(column_name) || ' from dept'from user_tab_columns where table_name='DEPT';

'CREATEORREPLACEVIEWASSELECT'||WM_CONCAT(COLUMN_NAME)||'FROMDEPT'

--------------------------------------------

create or replace view as select DEPTNO,DNAME,LOC from dept