How to use SQLPlus export data to csv format

Sqlplus opr1d/password@swoprdb1d.nam.nsroot.net:1521/OPRISKD1
set colsep '|'
set echo off

set feedback off
set linesize 1000
set pagesize 0

set trimspool on
set headsep off

spool output.dat

select .*
  from 
where 

spool off 
  
 
 
  
 

   
 
 

            

            
            

                            

            

                
                

                    
                        

                    
                

                

                    

                        上一篇
                        Oracle 10g使用游标更新或删除数据
                    
                    

                        下一篇
                        oracle工具:tkprof简析