Hi,

I have just started playing around with XML and wanted to test XML output from tables using SQL.

I have tried the following:

select xmlelement("Table name", table_name) from user_tables;

The result is just 130 rows of:

XMLTYPE()

I was expecting a XML output with tablenames.
What is wrong?

thanks,
Geir B