Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Extracting XML version and encoding from XML prolog in XMLType

User_ITSY5
Member Posts: 2 Green Ribbon
in XML DB
Hi,
Is it possible to extract XML version and encoding from XML prolog in XMLType with XML functions?
Let's say we have:
<?xml version="1.0" encoding="UTF-8"?>
<root>
</root>
I need to get either version and encoding values or whole XML prolog preferably with XML functions, f. ex. XMLTABLE. String/CLOB functions would be the second choice if that is not possible.