the problem is not generating an xml file. but displaying the xml file.
i want to have a look of the data in xml file. (xml output)
the fileds which i am selecting want to display in xml format.
select table_name, xmltype(dbms_xmlgen.getxml('select * from '||table_name)) from all_tables where owner = 'MAHIR';