-
hello all,
i have a text file which is like this
74,001,AFGHANI,, - -,
74,002,TURKEY,, - -,
74,003,CHINA OAK,, - -,
74,004,IRAN,, - -,
74,005,AMIRAN OAK,, - -,
74,006,PAKISTAN HK,, - -,
the table :-
icmasqua (company varchar2(2) primary key, masqua varchar2(3) NOT NULL,
name varchar2(30) NOT NULL,
family varchar2(2) NOT NULL,
lastupd date NOT NULL,
upduser varchar2(15) NOT NULL)
how can i write a control file to load data into the not null columns if there is no data for the respective fields in the text file ??
i know this control file wont work
LOAD DATA
INFILE 'c:\icmasqua.txt'
INTO TABLE icmasqua
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(company,masqua,name,family,lastupd,upduser)
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|