Export Sql query resultset to a comma separated file using JDBC

Question

I am polling a file from a unix directory , and creating a external directory using following command, and loading the data in the file as table. Later i am applying where condition on the table and the resultset should be exported as a comma separated csv file using JDBC .kindly let me know is it possible, or please point me to some blog .

Create or replace directory

and

Alter table

Snicolas · Accepted Answer · 2011-06-25 14:14:56Z

1

Here is a very good starting place. I personnally use some code inspired by their example and it works great to dump a resultset into a SQL file that you can load into a table very easily. You could adapt it to your needs in a few minutes.

answered Jun 25, 2011 at 14:14

Snicolas

38.2k15 gold badges118 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export Sql query resultset to a comma separated file using JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related