ctl 的写法_ORACLE sqlldr ctl导入数据

oracle ctl 文本数据导出导入实现(环境 oracle 9I 9.0.2)

bat 部分(通用部分)

cd Y:\1

sqlplus mobilenew@oral/password @Y:\1\6.sql

sql 部分 (导出)

set time off echo off head off;

set heading off

set term off

set pagesize 0

set colsep "," ---对导出数据相关信息列后以 逗号分隔

set trims on

set feedback off

set   linesize   1200

spool Y:\1\辽宁号码.txt

select to_char(d.phonenumber),

d.sex,

d.age,

d.customerstatus,

d.bookstatus,

to_char(d.begintime,'yyyy-mm-dd hh24:mm:ss'),

to_char(d.endtime,'yyyy-mm-dd hh24:mm:ss'),

to_char(d.ordertime,'yyyy-mm-dd hh24:mm:ss'),

d.timelength,

d.callstatus,

d.callbusinessid

from y_customer_info d;

spool off

/

quit

/

注意 以下部分为ctl导入文件写入方法 上面写法为sql写法

导入部分