[oracle@dj ~]$ vi shishi.ctl

LOAD DATA

INFILE *

INTO TABLE SHISHI

FIELDS TERMINATED BY ","

(ID,NAME)

BEGINDATA

1,XIAOCHU

2,XIAOMA

3,XIAOJIAO

4,XIAOSONG

5,XIAOCHEN

~

"shishi.ctl" [New] 11L, 134C written

[oracle@dj ~]$ sqlldr scott/oracle control=shishi.ctl

SQL*Loader: Release 11.2.0.4.0 - Production on Mon Jul 23 20:25:19 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Commit point reached - logical record count 5

SQL> conn scott/oracle

Connected.

SQL> create table shishi(id number(20),name varchar2(20));

Table created.

SQL> select * from shishi;

no rows selected

SQL> desc shishi;

Name Null? Type

----------------------------------------- -------- ----------------------------

ID NUMBER(20)

NAME VARCHAR2(20)

SQL> select * from shishi;

ID NAME

---------- --------------------

1 XIAOCHU

2 XIAOMA

3 XIAOJIAO

4 XIAOSONG

5 XIAOCHEN

LOAD DATA

INFILE *

INTO TABLE SHISHI

FIELDS TERMINATED BY ","OPTIONALLY ENCLOSED BY '"'

(ID,NAME)