Lists Home |
Date Index |
>Has any one knew how to get XML from an Oracle database table?
Try (a) XSU (XML SQL Utility)  for Java getXML, or (b) XSQL .
If you got SQL statements ready for porting, option a is pretty
straightforward, as all you need is place it into a java command
java OracleXML getXML -user <username/password> -conn <connection
string> <SQL statement>
The output is purely XML well-formed, therefore to be redirected to a
file if preferred.
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.
If you only wanted to pick up data from small number of table fields,
then option b can be considered.
Hope this helps.