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!

format XML Output

724773Nov 11 2010 — edited Nov 12 2010
Hi everyone

I have wrote this Query

SELECT XMLElement("xbrli:xbrl",
XMLAttributes('http://.......' AS
"xsi:schemalocation",
'http://....' AS
"xmln:n1",
'""' as id_num
)
) AS "RESULT"
FROM hr.employees
WHERE department_id = 10;

the outputis not well formated, is there any way to put CR or new line? , because i want to export the Output to an XML-file
and also in the Output i see ID_NUM="""" and i want to have ID_NUM="" how can i achieve that?

thanks in Advance

MDK.
This post has been answered by odie_63 on Nov 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2010
Added on Nov 11 2010
8 comments
634 views