Generate XML file with Customized XML tags out of oracle database table

[uaktags]

I am working on oracle database 9ir2I need to convert some tables into xml files with custom format tags.for example:I want to generate XML from some columns in emp table then generate a file with name "myxmlfile.xml" as following:\[code\]<?xml version="1.0" encoding="UTF-8"?><entity-engine-xml> <myxmlfile EMPNO="8401" ENAME="JHON" HIREDATE="1988-12-30" SAL="5000" DEPTNO="10" /> <myxmlfile ... /> <myxmlfile ... /></entity-engine-xml>\[/code\][*]how to generate custom XML file with tags as above, and everytime the user need to do so, in other words "per user request" by using pl/sql, how to use oracle XML functions to output customized desired tags?.[*]how to convert xmltype to varchar2 ??? ... to_char() function is unable to convert XMLtype to char.[*]what is the easiest way to create XML file on client side ?note: the user application is running on XP PCs, built by old oracle developer tools forms6i.