>Has any one knew
how to get XML from an Oracle database table?
You can try (a) XSU (XML SQL Utility)  for
Java getXML, or (b) XSQL .
If you already got SQL statements ready
for porting, option a is pretty straightforward, as all you need is put it into
a java command something like
java OracleXML getXML
-user <username/password> -conn <connection
string> <SQL statement>
The output is purely XML well-formed, can
be redirected to a file if preferred.
If you only wanted to pick up data from small
number of table fields, then option b can be considered.
For jdk1.2.x, xsu12.jar and JDBC2.x are
the environment you need to set up; otherwise xsu11.jar and JDBC1.x are for jdk1.1.x.
Hope this helps.