Xmlagg Syntax

-
The below formula will give you the columns in a row.

 Rtrim(rtrim(Xmlagg (Xmlelement (e , (C.DESCR) || ', ')).extract ( '//text()' ).GetClobVal() ,' ' ) ,',')



  SELECT Rtrim(rtrim(Xmlagg (Xmlelement (e 
 , (ETHNIC_GRP_CD) || ', ')).extract ( '//text()' ).GetClobVal() 
 ,' ' ) 
 ,',') FROM ps_divers_ethnic where emplid = '900000026' group by emplid


cid:e04061df-5dc9-4ee8-9dbb-676533428b80


 SELECT ETHNIC_GRP_CD FROM PS_DIVERS_ETHNIC WHERE EMPLID = '900000026';


cid:f252c617-bbd0-4e05-a22d-30a5725916b1

Comments

Post a Comment

Popular posts from this blog

BI Publisher: If Condition with sub-string in rtf template

-
 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;
Read more