--方法1
SELECT wm_concat(USER_NAME) FROM SYS_USER A ,SYS_USER_DATA_PERMISSION B
WHERE B.USER_CODE=A.USER_NAME AND B.ATTR='WHS' AND B.VALUE='T51W'
--方法2
SELECT listagg (A.USER_NAME, ',') WITHIN GROUP (ORDER BY A.USER_NAME) FROM SYS_USER A ,SYS_USER_DATA_PERMISSION B WHERE B.USER_CODE=A.USER_NAME AND B.ATTR='WHS' AND B.VALUE='T51W'
--方法1返回的是CLOB,
--创建视图时,distinct和CLOB列不能同时存在