Skip to Main Content

SQL & PL/SQL

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!

pretty printing xml with sql

user10647455Dec 19 2011 — edited Dec 19 2011
Hello
I have to pretty print xml which is stored in data base column ( clob)

My table
(
create table mytab 
myxml clob);
mydata
<?xml version="1.0" encoding="ISO-8859-1"?>
<Us name="Step">
<my name ="st">
<colol name="t"/>
</my>
</Us>
any idea/suggestion?

Edited by: user10647455 on Dec 19, 2011 2:04 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2012
Added on Dec 19 2011
2 comments
368 views