Having breaks in the XML result while working in OracleXML Return from an Oracle Stored ProcedureUsing Oracle SQL to generate nested XMLHow to get Oracle execution plan xml through jdbcBuilding SQL query in XML with a CDATA selectreturn stored proc results as XMLXML directly via querying ORACLE dbCan you use the oracle dataadapter to select an XML from a databaseextracting and saving xml results in file using SSISHow to use variable mapping while using Oracle OLE DB provider in SSIS?How to append XML (String) to XmlEventWriter (StAX) which already created the start of document
How are aircraft depainted?
Can I conceal an antihero's insanity - and should I?
Why is my fire extinguisher emptied after one use?
Parallel resistance in electric circuits
How are unbalanced coaxial cables used for broadcasting TV signals without any problems?
Some Prime Peerage
Sort files in a given folders and provide as a list
Is there any way to land a rover on the Moon without using any thrusters?
Is the Dodge action perceptible to other characters?
What is this gigantic dish at Ben Gurion airport?
How does a simple logistic regression model achieve a 92% classification accuracy on MNIST?
How do I say "quirky" in German without sounding derogatory?
If the gambler's fallacy is false, how do notions of "expected number" of events work?
Why do sellers care about down payments?
Is there a reliable way to hide/convey a message in vocal expressions (speech, song,...)
2000s space film where an alien species has almost wiped out the human race in a war
Why did it become so much more expensive to start a university?
Why did they ever make smaller than full-frame sensors?
How do certain apps show new notifications when internet access is restricted to them?
My research paper filed as a patent in China by my Chinese supervisor without me as inventor
What are uses of the byte after BRK instruction on 6502?
What organs or modifications would be needed for a life biological creature not to require sleep?
Does deswegen have another meaning than "that is why"?
Make 1998 using the least possible digits 8
Having breaks in the XML result while working in Oracle
XML Return from an Oracle Stored ProcedureUsing Oracle SQL to generate nested XMLHow to get Oracle execution plan xml through jdbcBuilding SQL query in XML with a CDATA selectreturn stored proc results as XMLXML directly via querying ORACLE dbCan you use the oracle dataadapter to select an XML from a databaseextracting and saving xml results in file using SSISHow to use variable mapping while using Oracle OLE DB provider in SSIS?How to append XML (String) to XmlEventWriter (StAX) which already created the start of document
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm trying to have breaks in my result while creating an XML output from oracle query. Right know the result is in string.
SELECT XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
FROM CTE ;
The output is
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
What i need to receive is
<OtherServices ServiceMonth="201903" Source ="ClientID" UniqueFileID ="UniqueFile">
<Service>
<BillingDriver>ViCS_PV</BillingDriver>
<Signum-ID>eeditur</Signum-ID>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
xml oracle
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
add a comment
|
I'm trying to have breaks in my result while creating an XML output from oracle query. Right know the result is in string.
SELECT XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
FROM CTE ;
The output is
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
What i need to receive is
<OtherServices ServiceMonth="201903" Source ="ClientID" UniqueFileID ="UniqueFile">
<Service>
<BillingDriver>ViCS_PV</BillingDriver>
<Signum-ID>eeditur</Signum-ID>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
xml oracle
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
add a comment
|
I'm trying to have breaks in my result while creating an XML output from oracle query. Right know the result is in string.
SELECT XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
FROM CTE ;
The output is
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
What i need to receive is
<OtherServices ServiceMonth="201903" Source ="ClientID" UniqueFileID ="UniqueFile">
<Service>
<BillingDriver>ViCS_PV</BillingDriver>
<Signum-ID>eeditur</Signum-ID>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
xml oracle
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
I'm trying to have breaks in my result while creating an XML output from oracle query. Right know the result is in string.
SELECT XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
FROM CTE ;
The output is
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
What i need to receive is
<OtherServices ServiceMonth="201903" Source ="ClientID" UniqueFileID ="UniqueFile">
<Service>
<BillingDriver>ViCS_PV</BillingDriver>
<Signum-ID>eeditur</Signum-ID>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
xml oracle
xml oracle
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
edited Mar 28 at 12:29
hotfix
2,77113 silver badges27 bronze badges
2,77113 silver badges27 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
asked Mar 28 at 10:24
RedelRedel
154 bronze badges
154 bronze badges
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
You can use the XMLSeralize function to prettify your result. As a demo with your current result as a literal:
select xmlserialize(
document
xmltype('<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile"><Service><BillingDriver>Central Mgmt Service</BillingDriver><Signum>SE001_RU0973</Signum><Quantity>1</Quantity><Billable>Yes</Billable></Service></OtherServices>')
indent size=2
) as result
from dual;
RESULT
-------------------------------------------------------------------------------------
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
So you can do:
SELECT XMLSERIALIZE(document
XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
indent size=2)
FROM CTE ;
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
add a comment
|
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55395233%2fhaving-breaks-in-the-xml-result-while-working-in-oracle%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use the XMLSeralize function to prettify your result. As a demo with your current result as a literal:
select xmlserialize(
document
xmltype('<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile"><Service><BillingDriver>Central Mgmt Service</BillingDriver><Signum>SE001_RU0973</Signum><Quantity>1</Quantity><Billable>Yes</Billable></Service></OtherServices>')
indent size=2
) as result
from dual;
RESULT
-------------------------------------------------------------------------------------
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
So you can do:
SELECT XMLSERIALIZE(document
XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
indent size=2)
FROM CTE ;
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
add a comment
|
You can use the XMLSeralize function to prettify your result. As a demo with your current result as a literal:
select xmlserialize(
document
xmltype('<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile"><Service><BillingDriver>Central Mgmt Service</BillingDriver><Signum>SE001_RU0973</Signum><Quantity>1</Quantity><Billable>Yes</Billable></Service></OtherServices>')
indent size=2
) as result
from dual;
RESULT
-------------------------------------------------------------------------------------
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
So you can do:
SELECT XMLSERIALIZE(document
XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
indent size=2)
FROM CTE ;
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
add a comment
|
You can use the XMLSeralize function to prettify your result. As a demo with your current result as a literal:
select xmlserialize(
document
xmltype('<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile"><Service><BillingDriver>Central Mgmt Service</BillingDriver><Signum>SE001_RU0973</Signum><Quantity>1</Quantity><Billable>Yes</Billable></Service></OtherServices>')
indent size=2
) as result
from dual;
RESULT
-------------------------------------------------------------------------------------
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
So you can do:
SELECT XMLSERIALIZE(document
XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
indent size=2)
FROM CTE ;
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
You can use the XMLSeralize function to prettify your result. As a demo with your current result as a literal:
select xmlserialize(
document
xmltype('<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile"><Service><BillingDriver>Central Mgmt Service</BillingDriver><Signum>SE001_RU0973</Signum><Quantity>1</Quantity><Billable>Yes</Billable></Service></OtherServices>')
indent size=2
) as result
from dual;
RESULT
-------------------------------------------------------------------------------------
<OtherServices ServiceMonth="201903" Source="ClientID" UniqueFileID="UniqueFile">
<Service>
<BillingDriver>Central Mgmt Service</BillingDriver>
<Signum>SE001_RU0973</Signum>
<Quantity>1</Quantity>
<Billable>Yes</Billable>
</Service>
</OtherServices>
So you can do:
SELECT XMLSERIALIZE(document
XMLElement("OtherServices",
XMLAttributes('201903' AS "ServiceMonth",
'ClientID' AS "Source",
'UniqueFile' as "UniqueFileID"),
XMLForest (
XMLForest (BillingDriver AS "BillingDriver",
Signum AS "Signum",
Quantity AS "Quantity",
Billable AS "Billable") AS "Service"
))
indent size=2)
FROM CTE ;
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
answered Mar 28 at 11:33
Alex PooleAlex Poole
143k7 gold badges117 silver badges199 bronze badges
143k7 gold badges117 silver badges199 bronze badges
add a comment
|
add a comment
|
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55395233%2fhaving-breaks-in-the-xml-result-while-working-in-oracle%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
