linux 导出数据

su - oracle -c "sqlplus -s user/password@IP:PORT/instance"<<eof

SET echo off

SET feedback off

SET newpage none

SET pagesize 50000

SET linesize 20000

SET verify off

SET pagesize 0

SET term off

SET trims ON

SET heading off

SET trimspool ON

SET trimout ON

SET timing off

SET verify off

SET colsep |

spool /usr/tmp/minyu.txt

select s_phone,d_update_time from tb_ethniclanguagembr where s_phone not in(select phone from phone_temp) and to_CHAR(d_UPdate_time,'yyyy-mm')<'2014-04' and n_buss_stat = 1;

spool off;

exit;

eof

 

从数据库的tb_ethniclanguagembr表导出数据到/usr/tmp/minyu.txt