This content has been marked as final. Show 3 replies
may be1 person found this helpful
with t as ( select sysdate datep from dual union all select null datep from dual ) -- select xmlagg(xmlelement("Reportf", case when datep is not null then XMLELEMENT("datep", datep) end ) ) from t
Now lets pretend thatXMLForest does that exactly :
is sometimes NULL and i do not want to display it.
(internally, it's equivalent to what Alex suggested)
XMLForest(datep as "datep")
thank you all for solving my problems.
XMLFOREST did the trick.