|
SQL Loader is a utility which allows you to import text based datas into an Oracle
table. We can easly import data from Excel files(CSV) and Txt files to Oracle. Using
a definition file (called control file), you can specify delimiters between columns.
(Space, comma,Tab, etc)
To run SQL Loader, we must create a control file first. Type the data below into
a txt file and save it as load.ctl.
LOAD DATA
INFILE ´C:/FileToImport.txt´
INTO TABLE MyOracleTableName
(Person_id POSITION(01:07) INTEGER EXTERNAL,
FirstName POSITION(08:20) CHAR,
LastName POSITION(21:31) CHAR,
email POSITION(32:48)
CHAR )
If your data does not have constant sizes like above, you may want to specify a
delimiter character like below.
LOAD DATA
INFILE ´c:/FiletoImport.txt´
INTO TABLE MyOracleTable FIELD TERMINATED BY ´,´ OPTIONALLY ENCLOSED
BY ´ " ´ (Person_id,FirstName,LastName,email)
Finally, to import your data from text file into your database, use the following
command.
C:>sqlldr hr/hr control=c:/load.ctl
log=c:/persloader.log
bad=c:/load.bad discard=c:/load.dis
|