输出类似 1月2日
select extract(month from sysdate)||‘月’||extract(day from sysdate)||‘日’ as time
行转列
SELECT listagg(JOBS_NAME,’,’) within GROUP (ORDER BY JOBS_NAME) jobs_Name
输出类似 1月2日
select extract(month from sysdate)||‘月’||extract(day from sysdate)||‘日’ as time
行转列
SELECT listagg(JOBS_NAME,’,’) within GROUP (ORDER BY JOBS_NAME) jobs_Name