Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle SQL XML Functions - How to get encoding in XML Prolog?

This SQL

SELECT XMLRoot(XMLType('<poid>143598</poid>'), VERSION '1.0', STANDALONE YES)
  AS xmlroot FROM DUAL; 

generates an output as follows

XMLROOT
--------------------------------------
<?xml version="1.0" standalone="yes"?>
<poid>143598</poid>

How can get encoding in my xml prolog?

Ex - I want output to be something like

XMLROOT
--------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<poid>143598</poid>

Reference -

Generate XML Data from the database

like image 280
jagamot Avatar asked Mar 31 '26 08:03

jagamot


1 Answers

select xmlroot (xmltype ('<poid>143598</poid>')
                  , version '1.0" encoding="UTF-8'
                  ) "XMLRoot"
  from dual;
like image 109
AnBisw Avatar answered Apr 02 '26 22:04

AnBisw



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!