Database Software

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!

Extracting XML version and encoding from XML prolog in XMLType

User_ITSY5Dec 15 2021

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.

Added on Dec 15 2021

#performance-availability, #pl-sql, #sql, #xml, #xml-db

0 comments

401 views