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!

Conditionally read from a path or another

Jose ArósteguiDec 22 2017 — edited Dec 23 2017

Hi experts,

I'm using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 .

I have a XMLTABLE query about invoices and the amount can be found in 2 different paths. I need to modify it to read the amount from one path and, if it's null, read it from the other path.

How can I do it?

Best regards,

Jose.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2018

Added on Dec 22 2017

#xml, #xquery

1 comment

585 views