Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the extracted values in sequence rather than concatenation of multiple ids. tried the bel

User_QDSE2Jun 27 2022

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

Comments

I think you mean "odd numbered".
Anyway, here is an example:
select * from (select ename,job, ROWNUM AS rn from emp) where mod(rn, 2) <> 0;

1 - 1

Post Details

Added on Jun 27 2022
#xml, #xquery
1 comment
126 views