Oracle exports TXT data and Excel Data

 

Export. bat

Sqlplus Prize / Prize @ Orcl1   @ D : \ AA. SQL

AA. SQL

Code
Set Trimspool On  
Set Linesize 120  
Set Pagesize 2000
Set Newpage 1  
Set Heading Off
Set Term Off  
Set Num 18
Set Feedback Off
Spool D: \ test.txt
Select Lrrq | ' ^ ' | Sfzh | ' ^ ' | Kprq | ' ^ ' | Fpdm | ' ^ ' | Fphm From Yj_sj Where Kc2 = 1 ;
Spool Off
EOF

 

 

Advantage: fast speed, and inconvenient to call in BS

CSProgramYou can also consider using it ..