在SQLPLUS中执行下列语句:
set heading off feedback off echo off termout off
spool /usr/local/filename.txt
select * from tablename;spool off;
在SQLPLUS中执行下列语句:
set heading off feedback off echo off termout off
spool /usr/local/filename.txt
select * from tablename;spool off;