Java Program to Convert Oracle database to a single SQL file.

Does anybody has idea of a java program that converts a oracle database(with multiple tables) to one single XML document?

I'm not sure it's possible to get all in to a one file, even if you could how you going to use it... Perhaps you may tell us the exact intention of doing this?

There are few tools that convert sql tables to a single XML file.
My database may not big as big as 4-5 tables, but I want to produce a program
that can flatten tables and convert them to a XML file (or store them in a XML file)

I do not have any dependencies as each of the tables are independent.

Thanks

Check dbtamer in my signature, it already reads and writes to an sql file, you can just modify to create a custom xml output.

"Basic Thogonomix", please check your private messages for an administrative matter.

look at XStream API .