Re: Create an XML-file from a select-statement in SQLPlus

Ole Hansen wrote:

> Hi !
>
> I am running Oracle 9i.
>
> Is there a way to create an XML-file from a select-statement in SQLPlus ???
>
> My statement is "SELECT FIRSTNAME, LASTNAME FROM EMPLOYEETABLE".
>
> I want to create an XML-file that looks like this:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <EMPLOYEETABLE>
> <EMPLOYEE>
> <FIRSTNAME>Ole</FIRSTNAME>
> <LASTNAME>Hansen</LASTNAME>
> </EMPLOYEE>
> <EMPLOYEE>
> <FIRSTNAME>Bill</FIRSTNAME>
> <LASTNAME>Gates</LASTNAME>
> </EMPLOYEE>
> </EMPLOYEETABLE>
>
>
> Do i need to install a special module or add-on to Oracle 9i ???
>
> Regards,
>
> Ole

Many. Here's one:
http://www.psoug.org/reference/dbms_xmlgen.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)