OraFAQ Forum: SQL & PL/SQL » preserve whitespaces in xml

Home » SQL & PL/SQL » SQL & PL/SQL » preserve whitespaces in xml

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

preserve whitespaces in xml [message #250353]

Mon, 09 July 2007 14:05

yerics
Messages: 89
Registered: August 2006

Member

I have a table that contains character data containing multiple whitespaces.
For eg a varchar2 column named RESOURCE_ENTITY containing data * *.
(lot of whiteSpaces between 2 stars).

When I use XMLAGG(XMLFOREST(Resource_entity as "ResourceEntity") in my sql query, the whitespaces are removed and the XML is displayed as
<ResourceEntity>* *</ResourceEntity>
instead of
<ResourceEntity>* *</ResourceEntity>

Any idea how to preserve the whitespaces.

Report message to a moderator

Re: preserve whitespaces in xml [message #250354 is a reply to message #250353]

Mon, 09 July 2007 14:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I can't see any difference between your 2 lines.
Maybe if you read and follow How to format your posts we can see it.
And maybe this is the same reason there is no difference in XML. Wink

Regards
Michel

[Updated on: Mon, 09 July 2007 14:09]

Report message to a moderator

Re: preserve whitespaces in xml [message #250356 is a reply to message #250353]

Mon, 09 July 2007 14:19

yerics
Messages: 89
Registered: August 2006

Member

Sorry for the post, xmlagg does seem to preserve whitespaces, but when I write it to a file using utl_file, it trims them. I will do some more research on this. Please ignore the query.

Report message to a moderator

Previous Topic:	what happens to dbms_scheduler.create_job's when import
Next Topic:	problem in the query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 11:15:57 CST 2024