i want to make xmlfile from database
like in emp table
i want to to take the data and convert it to xml

i want to make xmlfile from database
like in emp table
i want to to take the data and convert it to xml

82874[/snapback]

Hi fish
you can do

select xmlelement("Employees",
xmlagg(xmlelement("emp",
xmlforest(EMPNO,ENAME, JOB,MGR,HIREDATE))))
from emp;


or

SQL> SET AUTOPRINT ON
SQL> SET LONG 100000
SQL> VAR result CLOB
SQL> DECLARE
qryCtx DBMS_XMLGEN.CTXHANDLE;
BEGIN
qryCtx :=
DBMS_XMLGEN.NEWCONTEXT('SELECT employee_id AS "@id",
first_name AS "FirstName",
last_name AS "LastName",
email AS "Email",
phone_number AS "Phone"
FROM employees
WHERE salary > 20000');
DBMS_XMLGEN.SETROWSETTAG(qryCtx,'EMPLOYEES');
DBMS_XMLGEN.SETROWTAG(qryCtx,'EMPLOYEE');
:result := DBMS_XMLGEN.GETXML(qryCtx);
DBMS_XMLGEN.CLOSECONTEXT(qryCtx);
END;

thanks alot
we can use
xmlagg -- xmlelement --xmlforest
and the link discuss how to put in file
http://www.oracle-base.com/articles/9i/XMLGeneration9i.php