Problem to display results

XMLAttributes(‘’ AS

“xmlns:xsi”,’ AS


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.


Hi All,

I am executing below query in the Toad for Oracle 9.6.1.

SELECT XMLElement(“Employee”,