Newbie: Generate XML for data from Oracle Table Rows

Hi,

I am very new to Oracle. My customer has a requirement, where in I need
to generate the XML scripts for the data that we are appending with in
the table.

eg: for the table

col1 col2 col3
-----------------------------------------
Rohit Arora DEV
XXX ABC PROD

Then the xmls should be added to another field in table TBL_AUDIT:

<Tran>
<Data>
<Field Value="col1">
<old Val/>
<New Val>Rohit</New Val>
</Field>
......
......
..........

</Data>
</Tran>

Is there any tool to do so automatically or any sample code as to how
to do it.........

It will be of immense help.

Rgds,

Rohit

Rohit wrote:

>Is there any tool to do so automatically or any >sample code as to how
>to do it.........

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4980337843276

See also http://www.dbaoracle.net/readme-cdos.htm for posting clues.

jg
--
@home.com is bogus.
New Adventures of Old Gidget:
http://www.signonsandiego.com/uniontrib/20060421/news_2m21gidget.html