Forum Stats

  • 3,854,257 Users
  • 2,264,344 Discussions
  • 7,905,623 Comments

Discussions

Conditionally read from a path or another

Jose Aróstegui
Jose Aróstegui Member Posts: 1,358 Silver Badge
edited Dec 23, 2017 9:50AM in XQuery

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.

Answers

This discussion has been closed.