PLSQL 批量导出数据

在PL/SQL DEV左上角点击新建，选择命令窗口，然后输入以下内容

    set colsep '|'
    set heading off
    spool d:\ssss.txt; 
    select loan_code,account_code from sino_loanm where loanflag ='0' and  tran_flag ='0'and  rownum <= '5000' ; 
    spool off;