Toad World® Forums

Problem to display results


#1

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 4400

Any 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”,