Skip to Main Content

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!

Empty Tags with Extra Whitespace

PK_UpNorthMay 14 2019 — edited May 20 2019

I'm using XML DB on release12.1.0002. Specifically, I using a query with the xmlelement function to transform relational table data into XML.  The XML returned presents empty elements as self closing tags with whitespace before the '/'  as in "<ORDER_NOTES />".  The extra whitespace is problematic during subsequent processing.  Is there a setting or a way to remove it other than some sort of additional post processing?

Thanks,

Paul

Comments
Post Details
Added on May 14 2019
14 comments
4,329 views