C # to export large oracle table details (number 20 w +), the individual feels called oracle spool is faster, c #, please how to do?


Spool format is as follows:

The spool c: \ subsidiary. TXT
The set colsep ', '
Set the head on
The set pagesize 0
The set linesize 1000
The set term off
The set trimspool on
1.1 detail
-Select * from tab1;
Spool off;