利用Oracle的spool工具,可以自定义导出数据的格式
/***************************
* sql脚本部分 demo.sql begin
**************************/
/**************************
* @author wugang
* @date 20090519
**************************/
set pagesize 0
set arraysize 1000
set linesize 80
set numwidth 12
set echo off
set feedback off
set heading off
set termout off;
set timing off;
set trimout on;
set trimspool on;
spool d:\ctltest\data_new.txt;
select user_||','||ip||','||to_char(time_,'yyyy-mm-dd hh24:mm:ss')||','||channel||','||count_||','||vers||','||part_val from basechannelvisittab;
spool off;
eof
exit
/***********************
* demo.sql end
***********************/
然后执行:
sqlplus -S "ganwu/ganwu@ora_98" @demo.sql