extract data in csv from table with 2 billion records

Question

Wanted to know the tool which can extract data in csv from a table or by executing a sql query like

select * from table 1 inner join table 2 on ...

Data is currently in oracle database and required to be extracted in csv and processed through Java code and after processing final csv/multiple csv files required to be loaded back to same oracle database .

Is there any tool script does this task efficiently

Answer 1

I think this is a very bad idea. Anyway, you can use the ODBC Driver "Microsoft Text Driver (*.txt; *.csv)" which should be available on each Windows.

Setup the connection in ODBC Administrator odbcad32.exe

And then you can select the data with any generic ODBC capable SQL tool, e.g. WinSQL or DBeaver