Re: best way to extract the data from several tables into a file

mike hengins wrote: 
 hi,
I have to extract the data from several tables (Oracle is the database)
and insert them into a file, in a specified format.

Each column will be allocated a certain size (filled with empty spaces if size is too big), and I will assign a line for each record extracted from the tables. There wont be any delimiter.
Example of such line:
column1 colum2column2 column4 etc

So i am looking for ways to do it in Java, of course.
Thanks in advance for your suggestions and ideas.

What part of the job is giving you problems? It seems rather straightforward to me. Just build a SQL select statement which joins the necessary tables, then run through it, writing out the relevant lines one at a time. Where are you running into trouble?

Luke
.

Relevant Pages