SQL> set colsep '|';
SQL> set echo off;
SQL> set feedback off;
SQL> set heading off;
SQL> set pagesize 0;
SQL> set linesize 1000;
SQL> set termpool off;
SQL>alter session set NLS_DATE_FORMAT ="YYYY-MM-DD";
SQL> spool c:\emp.txt
SQL> select * from emp;
SQL>spool off;
sqlplus username/pwd@orasid
set head off feedback off pagesize;
aa.txt
select field1||','||field2||...... from tablename;
spool off
exit
执行完后,打开aa.txt,你所需的字段内容就打印在aa.txt文件中,你可以试着做一下。