练习八 spool导出

sqlplus -s username/password@sid
set trimspool on;
set linesize 120;
set pagesize 2000;
set newpage 1;
set heading off;
set term off;


spool sys_user.txt;

select col1||','||col2||','||col3||','||col4||'..' from sys_user; spool off;

exit;
原文地址:https://www.cnblogs.com/cici-new/p/4031156.html