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

[Quoted] 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>

Do i need to install a special module or add-on to Oracle 9i ???

Regards,

Ole Received on Sat Jul 03 2004 - 19:55:07 CEST