linux ä¸ï¼å¯ä»¥ä½¿ç¨cliç¨åºæcsvæ件导å
¥å°æ°æ®åºãå
·ä½ä»£ç å¦ä¸ï¼
$ORACLE_HOME/bin/sqlplus -S username/password@instanceName > /dev/null 2>&1 <<!!
#对sqlplusä½ä¸äºè®¾ç½®ï¼ä½¿ä¹åªè¾åºæ们éè¦çææ¬
set echo off
set pagesize 0
set verify off
set feedback off
set termout off
set linesize 3000
set trimspool on
#æ¥è¯¢è¾åºå°ä¸´æ¶æ件
spool /tmp/some_tmp.csv
#selectè¯å¥
select column1||','||column2||','||column3 ....
from some_table where condition
spool off
#è¿éå¯ä»¥æ·»å å¤ä¸ªæ¥è¯¢,ä¸æ¯ä¸ªæ¥è¯¢å¯è¾åºå°ä¸åçæ件,å¦ä¸é¢æ³¨é
#spool /tmp/some_tmp.csv
#select column1||','||column2||','||column3 ....
#from some_table where condition
#spool off
set markup HTML off
quit
!!
#计ç®è®°å½æ»è¡æ°ï¼å¦ææ¯0åä¸åé®ä»¶
NUM=`cat /tmp/some_tmp.csv | wc -l`
if[ $NUM -gt 0 ]
then
#å
åexcelçæ¯åçtitle
echo 'Title_Of_Column1, Title_Of_Column2, ....Title_Of_ColumnN' > /tmp/attachement.csv
#æ°æ®æ£æ
cat /tmp/some_tmp.csv >> /tmp/attachement.csv
#åé®ä»¶
(
echo "From:
[email protected]"
echo "To:
[email protected]"
echo "MIME-Version: 1.0"
echo "Content-Type: multipart/mixed;"
echo ' boundary="A_Boundary_Name_You_Can_Change_It"'
echo "Subject: Subject"
echo ""
echo ""
#é件åé符ï¼ä¸é¢çboundaryåé¢å --
echo "--A_Boundary_Name_You_Can_Change_It"
echo 'Content-Transfer-Encoding: x-uuencode'
echo 'Content-Type: text/csv;'
echo ' name="attachement.csv"'
echo 'Content-Disposition: attachment;'
echo ' filename="attachement.csv"'
echo ""
uuencode /tmp/attachement.csv attachement.csv
echo "--A_Boundary_Name_You_Can_Change_It"
#é件ç»æ
) | mailx -t
fi
#å é¤ä¸´æ¶æ件
rm -f /tmp/*.csv
exit 0