Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to import Excel into Oracle database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to import Excel into Oracle database" this article.

1. Enter the excel test form, test.xls.

two。 Save as .csv format

3. Create the sql*loader control file test.ctl, which contains the following:

Load data

Infile'c:\ test.csv'

Insert Into table test Fields terminated by','(column1,column2,column3,column4,column5)

The data file needs to be copied to the corresponding location

4. Create the corresponding test table test in the database

Create table test (

Column1 Varchar2 (10)

Column2 Varchar2 (10)

Column3 Varchar2 (10)

Column4 Varchar2 (10)

Column5 Varchar2 (10)

)

5. Execute the import command

Sqlldr userid = system/123456 control='C:\ test.ctl'

Import succeeded!

Attached:

The function keyword description of Sqlldr:

Userid--oracle user name userid = username/password

Control-- Control file name control ='e:\ insert.ctl'

Log-- log file name log ='e:\ insert.log'

Bad-- corrupted file name

Data--data file name

Discard--discard file name

Discardmax-- number of discards to allow (default all)

Number of record rows skipped on Skip-- import (default 0)

Number of rows of records imported on Load-- import (default all)

Errors-- allows incorrect rows of records (default 50)

Ctl file content description:

Load data

Infile'e:\ test.csv'-- data source file name

Append | insert | replace--append is appended to the table, insert is inserted into the empty table, and replace replaces the original content.

Name of the database table to be imported by Into table test--

[when id = id_memo]-filter condition

Fields terminated by Xsepar09'-field delimiter

(id,name,telphone)-list of field names

The above is all the contents of the article "how to import Excel into Oracle database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.