How to processing XML with multiple nodes (using XMLSequence in Oracle)

XML, which contains multiple nodes is necessary in the Oracle database parse with function XMLSequence. I will show you the application in three versions. First, with no XML namespace, then with the defined XML namespace and eventually use directly in the SQL expression. What is XML, or XML namespace, see W3Schools. [Česká verze článku –…