Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!border1.nntp.ash.giganews.com!nntp.giganews.com!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: hari_om@hotmail.com (Hari Om)
Newsgroups: comp.databases.oracle.server
Subject: Oracle to XML Conversion
Date: 2 Feb 2004 13:05:19 -0800
Organization: http://groups.google.com
Lines: 13
Message-ID: <d1d5ebe4.0402021305.3b5285c5@posting.google.com>
NNTP-Posting-Host: 168.179.100.240
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1075755920 22275 127.0.0.1 (2 Feb 2004 21:05:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Feb 2004 21:05:20 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253487

I am using Oracle 9.2.0.4 on IBM AIX 5.1L.
I have a instance named "GATES" which has around 100 tables.

I would like to extract some data from these tables and make an XML
file out of it. I then have to UPLOAD this XML File to other
Applicaiton.(this other application is designed to accept only XML
File formats)

My question is what is the best possible way to move data from
Relational Tables to and XML File? Any related information on this is
appreciated.

THANKS!