-
hi guys,
I have a question regarding the sqlldr in oracle. It is about the control file. I have a input .csv file, and I would like to load the csv column 'COUPON' to two of my database columns, let's say 'INTEREST_RATE' and 'COUPON'. is it possible to do that in sqlldr? How should the control file look like? Please take a look at what I have here.
my input file: 'data190.csv'
----------------------------------------------
DEAL_NUM, LOAN_NUM, COUPON
MyTest,100,8.7
MyTest2,201, 9.3
MY control file
---------------------
Code:
LOAD DATA
INFILE 'data190.csv'
REPLACE
INTO TABLE LOAN_TEMP
fields terminated by ',' TRAILING NULLCOLS
(
DEAL_NUM CHAR NULLIF DEAL_NUM=BLANKS,
LOAN_NUM INTEGER EXTERNAL NULLIF LOAN_NUM=BLANKS,
COUPON DECIMAL EXTERNAL NULLIF LOAN_WAC=BLANKS,
INTEREST_RATE DECIMAL EXTERNAL NULLIF LOAN_WAC=BLANKS
)
In the data file, I have 3 columns but in the control file I have 4 columns, so I don't think the control file above will work. Anyone has an idea on how to handle this kind of problem?
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
|