SELECT ACCT_MONTH, TABLE_NAME,dbms_lob.substr(wmsys.wm_concat(PROV_ID),8000) from zb_src.serv_cbss_file_prov_log_DW3 t
where acct_month = to_char(sysdate - 9, 'yyyymmdd')
AND TO_CHAR(TO_DATE(UP_FILE_ENDTIME,'YYYYMMDDHH24MISS'),'HH24:MI:SS')>'06:00:00'
and T.TABLE_NAME IN
('zbg_dwa.dwa_v_d_cus_cb_user_info',
'zbg_dm.dm_c_d_use_kb_voice')
GROUP BY TABLE_NAME,ACCT_MONTH