Adding <?xml-multiple?> in select statement

Question

I select data from an Oracle SQL database using XMLELEMENTs. These data get passed to an application that will convert it into JSON and then sends it to a REST API.

Currently, I have the same issue as here, and the solution should be to add <?xml-multiple?> as a tag.

How can I select it from the database?

SELECT XMLEMENT("Body", 
XMLELEMENT("User", 
XMLELEMENT("Name", UserName), 
XMLELEMENT("Adress", Adress))) 
FROM USERS;

Let's say I want to mark that there could be multiple users with xml-multiple. How do I need to change my query?

Garett · Accepted Answer · 2019-01-25 23:50:28Z

0

How about using the XMLPI function. It allows you to add processing instructions to the XML.

SELECT XMLEMENT("Body", 
XMLPI("xml-multiple"),
XMLELEMENT("User", 
XMLELEMENT("Name", UserName), 
XMLELEMENT("Adress", Adress))) 
FROM USERS;

answered Jan 25, 2019 at 23:50

Garett

16.9k5 gold badges58 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding <?xml-multiple?> in select statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related