Get Started with Redwood: Oracle Cloud SCM and Purchasing
line feed when displaying getclob() using data model in oracle cloud
Summary
line feed when displaying getclob() using data model in oracle cloudContent
select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).GetClobVal(),',') id
from (select level as id from dual connect by level < 1050)
When I run this query I am getting two lines. First column in the first line I get the sysdate, in the Second column I get id in the second line instead of first line.
Can any one help me resolving this issue in oracle cloud BI data model.
Thanks in advance.
Tagged:
1