XMLAttributes(‘http://www.w3.org/2001/XMLSchema’ AS
“xmlns:xsi”,
‘http://www.oracle.com/Employee.xsd’ AS
“xsi:nonamespaceSchemaLocation”),
XMLForest(EmployeeID, PersonalID, Salary)) AS “RESULT”
FROM employee
But its not showing the result instead its showing in each colum of the row ‘(ORAXML)’
What I am missing in the query? to display the result like below :
200 Whalen 4400Any help will be much appriciated.
Thanks
John
Hi All,
I am executing below query in the Toad for Oracle 9.6.1.
SELECT XMLElement(“Employee”,