SELECT LISTAGG(a.lineout) WITHIN GROUP (ORDER BY a.seq,a.sort_by) AS lineout
FROM (
SELECT
1 SEQ
,'' SORT_BY
,'<!--HTML--><table width="100%" class="sectionWFStatusTable" borderColor="blue" border="0" cellSpacing="0" cellPadding="0" marginwidth="0" marginheight="0" topmargin="0" leftmargin="0"><tr><th class="promptTd firstPromptTd" scope="col">User Name</th><th class="promptTd" scope="col">First Name</th><th class="promptTd" scope="col">Last Name</th></tr>' AS LINEOUT
FROM DUAL
UNION
SELECT
3 SEQ
, '' SORT_BY
,'</table>' AS LINEOUT
FROM DUAL
UNION
SELECT
2 SEQ
,last_name SORT_BY
,'<tr class=""><td class="valueTd firstCell">'
||'username'||'</td><td class="valueTd" noWrap="">'
||first_name||'</td><td class="valueTd" noWrap="">'
||last_name||'</td><td class="valueTd" noWrap="">' AS LINEOUT
FROM hr.employees
WHERE ROWNUM < 10
) a| LINEOUT | <!--HTML--><table width="100%" class="sectionWFStatusTable" borderColor="blue" border="0" cellSpacing="0" cellPadding="0" marginwidth="0" marginheight="0" topmargin="0" leftmargin="0"><tr><th class="promptTd firstPromptTd" scope="col">User Name</th><th class="promptTd" scope="col">First Name</th><th class="promptTd" scope="col">Last Name</th></tr><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Ellen</td><td class="valueTd" noWrap="">Abel</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Sundar</td><td class="valueTd" noWrap="">Ande</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Mozhe</td><td class="valueTd" noWrap="">Atkinson</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">David</td><td class="valueTd" noWrap="">Austin</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Hermann</td><td class="valueTd" noWrap="">Baer</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Shelli</td><td class="valueTd" noWrap="">Baida</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Amit</td><td class="valueTd" noWrap="">Banda</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Elizabeth</td><td class="valueTd" noWrap="">Bates</td><td class="valueTd" noWrap=""><tr class=""><td class="valueTd firstCell">username</td><td class="valueTd" noWrap="">Sarah</td><td class="valueTd" noWrap="">Bell</td><td class="valueTd" noWrap=""></table> |
|---|