When I add .getBlobVal(nls_charset_id('AL32UTF8')) to this query beautifier format this query to one line
Without this section everything works fine:
SQL:
select XMLElement("ns3:Tag1", xmlattributes('http://someexampledomain.pl/someLongName' as "xmlns", 'http://someexampledomain.pl/someLongName/someLongName2' as "xmlns:ns2", 'http://someexampledomain.pl/someLongName/someLongName/someLongName3' as "xmlns:ns3"), XMLElement("ns3:Tag2", XMLElement("Tag3", 'Tag3 value'), XMLElement("Tag4", XMLElement("ns2:Tag5", 'Tag5 Value')))).getBlobVal(nls_charset_id('AL32UTF8'))
from dual
Without this section everything works fine:
SQL:
select XMLElement("ns3:Tag1",
xmlattributes('http://someexampledomain.pl/someLongName' as "xmlns",
'http://someexampledomain.pl/someLongName/someLongName2' as "xmlns:ns2",
'http://someexampledomain.pl/someLongName/someLongName/someLongName3' as "xmlns:ns3"),
XMLElement("ns3:Tag2", XMLElement("Tag3", 'Tag3 value'), XMLElement("Tag4", XMLElement("ns2:Tag5", 'Tag5 Value'))))
from dual