1.行转列
select wm_concat(kpSize) kpSize from(
SELECT
sp."PRD_PLAN_ID" AS 作业计划号,
'('||rownum||')【'||sco."PRD_LENGTH"/1000||'米'||sco."PRD_ORD_NUM"||'张】'
AS kpSize
FROM
"SC_PLAN" sp INNER JOIN "SC_ORDER" sco ON sp."PRD_PLAN_ID" = sco."PRD_PLAN_ID"
WHERE
sp.PRD_PLAN_ID = 'ZJ1612220138') t;
--(1)【1米100