Ö±½Ó¸ù¾Ýsql½«²éѯ½á¹û°´ÕÕ¸ñʽÉú³ÉÎļþ£¬ÏÂÃæÊÇÇ°ÃæÉú³ÉµÄ¸ñʽÉ趨¡£
set colsep¡¯ ¡®;¡¡¡¡¡¡ //ÓòÊä³ö·Ö¸ô·û
set echo off;¡¡¡¡¡¡¡¡//ÏÔʾstartÆô¶¯µÄ½Å±¾ÖеÄÿ¸ösqlÃüÁȱʡΪon
set feedback off;¡¡¡¡//»ØÏÔ±¾´ÎsqlÃüÁî´¦ÀíµÄ¼Ç¼ÌõÊý£¬È±Ê¡Îªon
set heading off;¡¡¡¡ //Êä³öÓò±êÌ⣬ȱʡΪon
set pagesize 0;¡¡¡¡¡¡//Êä³öÿҳÐÐÊý£¬È±Ê¡Îª24,ΪÁ˱ÜÃâ·ÖÒ³£¬¿ÉÉ趨Ϊ0¡£
set termout off;¡¡¡¡ //ÏÔʾ½Å±¾ÖеÄÃüÁîµÄÖ´Ðнá¹û£¬È±Ê¡Îªon
set trimout on;¡¡¡¡¡¡//È¥³ý±ê×¼Êä³öÿÐеÄÍÏβ¿Õ¸ñ£¬È±Ê¡Îªoff
set trimspool on;¡¡¡¡//È¥³ýÖض¨Ïò£¨spool£©Êä³öÿÐеÄÍÏβ¿Õ¸ñ£¬È±Ê¡Îªoff
Àý×Ó£º
×î¼òµ¥£º
set heading off;
set trimspool on;
spool d:\11.txt;
select bankid||¡¯,'||t.customername from rich_customerinfo t;
spool off;
±È½ÏÆëÈ«£¬ÇÒµ¼ÈëÊý¾Ý²»³öÏÖÎÊÌâ
set trimspool on;
set linesize 120;
set pagesize 2000;
set newpage 1;
set heading off;
set term off;
spool d:\11.txt;
select bankid||¡¯,'||t.customername from rich_customerinfo t;
spool off;