Newbie: Generate XML for data from Oracle Table Rows

From: Rohit Arora <rohit.x.arora_at_gmail.com>
Date: 21 Apr 2006 05:06:45 -0700
Message-ID: <1145621205.425955.233190@i39g2000cwa.googlegroups.com>

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 Received on Fri Apr 21 2006 - 07:06:45 CDT