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!

query to filter out in XMLSEQUENCE

693241Mar 29 2009 — edited Apr 3 2009

Hello all,

I am new to xml concepts.
The below query,
Gives me result count of 100 out of which i need to filter out particular record say 999999999 how to i do that?

SELECT extractvalue(VALUE(p),'/CUSTOMER_NO') a
FROM test_clob w,
TABLE(XMLSEQUENCE(EXTRACT(xmltype(xml_file), '/RECEIVABLES/CUSTOMER/CUSTOMER_NO'))) p

A
1954365
999999999
....

Thanks in advance
Vijay G
6721

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2009

Added on Mar 29 2009

#general-xml, #xml

7 comments

3,088 views