Thread: Help with control file
10-17-05, 06:41 #1Registered User
- Join Date
- Aug 2005
- Kuala Lumpur, MY
Unanswered: Help with control file
10/10/2005 00:00:02 modbalrel - ok (msisdn = 60163050499, amount=1000, val_period = 7, seq_nb = 199370643 , balance = 1055, va
ldate = 08/11/2005) (48 ms)
10/10/2005 00:00:03 modbalrel - ok (msisdn = 60162433164, amount=1000, val_period = 7, seq_nb = 199370644 , balance = 987, val
date = 03/11/2005) (133 ms)
this is the ctrl file i written :
APPEND INTO TABLE trap_ra_k2_ain_balance
FIELDS TERMINATED BY ","
DATE_LOADED "(SELECT sysdate FROM dual)",
WEEK_NO "(sELECT to_char(sysdate,'WW') FROM dual)",
I want to load this file into my oracle database and the last two columns should be uploaded with this data
balance = 1055,amount=1000
balance = 987,amount=1000
(IN WHICH i must specify from a space untill the field separator ',') and im not sure how to do it... I cant specify a position because the spaces are different and it accidentally takes the other values into the column...
anyone can help me ??
pls do not give me hints since its urgent....
and anyone could help me write a .sh file for this to find sysdate-1 and load
10-19-05, 10:31 #2Registered User
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
- Join Date
- Jun 2003
- West Palm Beach, FL