how to read a text file from a database table

[parag Chatterjee]

Can anybody help me out how to read a text file from a databse table using JDBC .
I need to know
1. what will be the query to extract the file?
2. what will be the jdbc snippet of code
3.

[parag Chatterjee]

I also need to know how to store the file in local disc

[Mahesh swami]

U can use,rs.getObject() or rs.getBinaryStream() and then read from the stream.

[parag Chatterjee]

Thanks a lot.
I had already used it with rs.getAsciiStream()