format XML Output
724773Nov 11 2010 — edited Nov 12 2010Hi 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.