Hi,
I have a sample DataFile.txt file which has two records of 7 fields each separated by "tab" delimiter.
I want to load this file into Oracle Db by using the ctl file by name "World.ctl" into the sample table by name "World".
Last two fileds will allow NULL values. please find the attachment.
The contents of a ctl file is as below
=====================
LOAD DATA
INFILE 'C:\ABCL\ABCDATA\DataFile.txt'
INTO TABLE WORLD
FIELDS TERMINATED BY x'09'
LINES TERMINATED BY '\n'
OPTIONALLY ENCLOSED BY '"'
===========================
By using the above code i am not able to upload the data through control file. Is there any special line of code i have to write to control null values.
i would be greteful if any one of you could please let me know the possible error behind the code?