在sql plus中运行如下命令:
set heading off;
set echo off;
set linesize 250;
spool d:/2005.txt;
select jd||',',wd||',',time||',',xp from radar_info;
spool off;
成功生成2005.txt文件后打开看是如下内容:
119.3456, 34.5674, 200502071113, 123433
......
set heading off;
set echo off;
set linesize 250;
spool d:/2005.txt;
select jd||',',wd||',',time||',',xp from radar_info;
spool off;
成功生成2005.txt文件后打开看是如下内容:
119.3456, 34.5674, 200502071113, 123433
......