XML data collection

hi,

i want to retrieve data from database through a XML.

the thing is earlier i had a java file which had a getter method to retrieve data from database.

now i should not use that java file and make it using only the xml.

any ideas?

anybody have an idea about this?

You might want to look at XQuery:

http://en.wikipedia.org/wiki/XQuery

I am not very clear about you question.Could you please elaborate it again.

Is the data stored in database in the form of an XML in a CLOB field ,or you want your java program to fetch data from a database and construct a xml out of it and then give it to the invoker.Is that you want ?

data in database is in the form of sql tables which has to be retrieved using a xml and displayed.

do i need to write query in the xml??

what if i just write a simple query in xml?
like

<sql>select * from ABC</sql>

Originally posted by prasanna sheregar:
data in database is in the form of sql tables which has to be retrieved using a xml and displayed.

Sorry , I still could not get your question.
Data is stored in database tables but what is the data type ? Is that CLOB ?
How can you retrieve data from database using XML?

i want to retrieve data from a database through XML

ie i can change only XML document

can i write a sql in a xml document itself?

data is stored in terms of tables.

which has to be retrieved and displayed

the catch is i have to do it by changing only xml