首页 > 代码库 > 练习八 spool导出

练习八 spool导出

sqlplus -s username/password@sidset 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;

 

练习八 spool导出