练习八 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;

 

posted @ 2014-10-17 14:54  王超_cc  阅读(145)  评论(0编辑  收藏  举报