oracle wm_concat函数，用于列转行，逗号分隔??SQL select create or replace view as select || wm_conc
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