CODE EXAMPLE FOR SQL

oracle sql get value from several rows and concatenate strings

SELECT pid, LISTAGG(Desc, ' ') WITHIN GROUP (ORDER BY seq) AS description
FROM B GROUP BY pid;