How to get the table from the database in the form of XML

Hi,

How to get the table from databse in form of xml?

The data in database is normal data that is not in the form of xml.

I need to get that data as xml format.( I don't want to convert this into xml).

Please give reply.

Sample code is helpful.

Thanks in Advance.

Regards.

Raghava

[336 byte] By [RAGHAVAa] at [2007-10-2 13:32:55]
# 1
Hi, if I understood well you want the results as xml? Is that right? This can be dependent on the rbmds you use. In SQL Server you can add at the end of the select statement "FOR XML" and that's it. What rdbms do you use?Kiros
kiros1979a at 2007-7-13 11:19:37 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Retrieve the table data with XML SQL Utility. http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14252/adx_j_xsu.htm#sthref442
dvohra09a at 2007-7-13 11:19:37 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...