How to get the extracted values in sequence rather than concatenation of multiple ids. tried the below approach but not working, receiving like "SYS.XMLSEQUENCETYPE(00000)"
select xmlsequence(extract(xmltype(message), 'aaa/bbb/ccc/@Id')) from xxxx;
Under bbb, there are multiple ccc so different ids
I should get value as
id1
id2
but not as id1id2