我用记事本编写了一个段数据,
load data
infile*
into table bonus
fields terminated by ","
(ename,job,sal)
begindata
smith,cleak,3904
allen,salesman.2891
ward,salesman,3128
king,president,2523
我想通过输入sqlldr scott/tiger control=ldr_case1.ctl命令将其导入,该怎么给这个记事本命名?然后放在哪个文件目录下?
load data
infile*
into table bonus
fields terminated by ","
(ename,job,sal)
begindata
smith,cleak,3904
allen,salesman.2891
ward,salesman,3128
king,president,2523
我想通过输入sqlldr scott/tiger control=ldr_case1.ctl命令将其导入,该怎么给这个记事本命名?然后放在哪个文件目录下?
sqlldr scott/tiger control=c:\case1.ctl3、注意,在记事本存盘时,在“保存类型”里要选择“所有文件”,避免它自动为你加一个.txt。