SQL & PL/SQL

Hello,

I need help to export 1.5 billion data onto csv file in chunk.   I tried to use the sqldeveloper and can't put the "object where".  It hung and terminate the wizard.

I tried to run on sqlplus and set sqlformat csv, I get an error SP2-0158: unknown SET option "sqlformat"

I even use "define sqlformat = csv".  The select * from table where ... ;

this give me a result but not in csv format.

How do I export oracle data only csv with columns specified and where clause?

thank you,

Bach-Nga