sqlplus导出记录另存为CSV格式
#################################################
##
## File name: exp2csv.sh
## Author: zhangqiao
## Copyright: zhangqiaoc@olm.com.cn
##
#################################################
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export NLS_LANG=american_america.ZHS16GBK
mknod tmp.txt p
cat tmp.txt|grep -v "SQL>"|sed 's/^/"/'|sed 's/$/"/'|sed 's/ *",/",/g'|sed 's/" */"/g' > $2.csv &
sqlplus -S "/as sysdba" < /dev/null
set colsep '","'
set pagesize 0
set trimspool on
set trim off
set feedback off
set headsep off
set linesize 9999
set termout off
set numw 20
set arraysize 5000
spool tmp.txt
$1
spool off
EOF
##
## File name: exp2csv.sh
## Author: zhangqiao
## Copyright: zhangqiaoc@olm.com.cn
##
#################################################
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export NLS_LANG=american_america.ZHS16GBK
mknod tmp.txt p
cat tmp.txt|grep -v "SQL>"|sed 's/^/"/'|sed 's/$/"/'|sed 's/ *",/",/g'|sed 's/" */"/g' > $2.csv &
sqlplus -S "/as sysdba" <
set colsep '","'
set pagesize 0
set trimspool on
set trim off
set feedback off
set headsep off
set linesize 9999
set termout off
set numw 20
set arraysize 5000
spool tmp.txt
$1
spool off
EOF
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-742812/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
