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
select xmlroot (xmltype ('<poid>143598</poid>')
, version '1.0" encoding="UTF-8'
) "XMLRoot"
from dual;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With